All media have strengths and weaknesses. The Domesday Book has lasted quite well, but I'm only aware of one of them.

Optical media sounds better than what it is. Much of it is cheap and short lasting (CDs with ultra thin metal layers sequestered within cheap plastic.

Magnetic media may be bad or good depending on quality. I've got some fifty year old cassettess in good condition. And a very few open reel tapes which held up from the 60s in time to be digitized.

Once digitized you are not 'safe' because you need to be able to play the encoded material.

I'll bet some player piano turns up on a distant planet with the only music left after millenia of human effort. Probably a Scott Joplin Rag.