Most writable optical media use organic dyes that aren’t stable for more than a couple years—if you can still read the contents 10 years later, consider yourself lucky.

M-DISC use a more stable media, and should last much longer, but are (much) more expensive and require more recent burners. There are dual-layer M-DISC with higher capacities, too.

I did a bunch of research on long-term data archival and wrote it up here: https://photostructure.com/faq/how-do-i-safely-store-files/