Just last week, I was looking for some old data. I dug through a small collection of cheap CD-R backups from 30 years ago (hard to believe the tech is that old!). Probably 12 discs in total. No problem physically reading any of them. The only issue is that one of them was recorded in an old pre-OSX Mac format that my Linux laptop struggled with, but I was able to access it on my 2015 MacBook.
If this 20ish gigs of data hasn't had a single bit of corruption, I doubt most of the other discs in climate controlled storage in multiple locations have had much errors either.
Even the newer ones will still degrade quite rapidly in direct sunlight, so the method of storage is also important (spindles in your bookcase that get hit by sunlight = bad).
https://en.wikipedia.org/wiki/CD-R#Dyes
FWIW I archived all my CD-Rs and DVD-Rs when the oldest ones were just about 15 years old and aside from one ultra-cheap disc where the top was literally flaking off they all read fine in ddrescue.
Sure, almost all my cheap ones have died out, but even some of those are still pretty OK.