I was ripping my entire DVD collection and I lost at least 3 movies to disc rot. They looked perfectly good, no scratches or anything when looking in the light, and I’ve always taken good care of my discs (out of sunlight, in their cases, in my house) and yet multiple players just could not read some or all of the disc.

My old music CDs still work on the stereo and I bought some of my Megadeth albums in 2011. Perhaps music lasts longer than data.

I refuse to believe you have burned and then later used more than a handful of discs if that's not happened to you. I've seen it many, many times.

It depends on the type of CD you used. The older ones with a Gold layer didn't degrade as much.