For starters how common is a cd drive these days? Apple deleted them nearly a decade ago.

Second, you could Google or look at the Wikipedia page for i don't know, CD-R, section Lifespan,

https://en.m.wikipedia.org/wiki/CD-R?wprov=sfla1

"Real-life (not accelerated aging) tests have revealed that some CD-Rs degrade quickly even if stored normally. The quality of a CD-R disc has a large and direct influence on longevity—low quality discs should not be expected to last very long. According to research conducted by J. Perdereau, CD-Rs are expected to have an average life expectancy of 10 years."

Part of the problem with long term storage is the equipment needed to read media gets less common. It's a problem that libraries and the Internet Archive are working hard to solve. By the way do you know what they use for storage? Hard disks arranged in 1petabyte pods.