The chemical processes are pretty much reversible, leading to dead CDs. The physical processes are much more robust, as you'd have to deform the actual base plastic, like cooking vinyl LPs in the sun.
In sum, some 3,800 CDs. I ripped them all a couple of years ago - I had problems with a handful, but EAC eventually got them all to disk. I examined the troublesome ones, but no (visual) signs of disc rot.
They did replace 300 with a Blu-Ray copy (this was after HD-DVD was obviously on its way out), but the rest didn't fail until much later or were bought used for literally pennies.
For pressed CDs, I can't ever remember getting one that was unreadable and not obviously scratched (though I did have a game CD shatter into hundreds of pieces in the drive).
I'm lucky that I've not suffered any rot yet but it's only a matter of time for me because I don't store them properly either.