Discs with minor scratches that might lead to extra work for the tracking system of the CD player can be resurfaced.
Disc rot is however impossible to fix. While I am lucky to not have (yet) a CD stored console game that got damaged, I have a few silver CD audio bought in the nineties that are affected by debonding or corrosion, and many more cheap CD-R that are just dead now.
Depending on the source, the announced life expectancy of a silver CD greatly varies from 50 to 200 years, given it is stored in ideal conditions and did not have manufacturing defect to start with.
Bottom line, depending how old you are and the speculated quality of PCE CD, all, most, or only some should survive you, and not forever. Obviously, more and more problems will emerge in the coming decades, you can avoid the worst by always examining carefully against the light your purchases, and pay a close look to the inner and outer borders.
So I'd say it's a legitimate question, but it will ultimately be weighted by what is driving your collection purpose. Games are meant to be played one might say naively, so disc rot seems important right now, but looking at examples of collecting other much older cultural artefacts, you will often see that the motivation can shift through time. For instance, wine bottles that are initially meant to be drunk, can end up past their acceptable consumption date (meaning it has became dead corpse juice) yet be still highly collectable. So I can imagine that once all the Sapphire copies (including sealed) will have rotten, they will be still valuable, maybe more, maybe less, to a few, somewhere, sometime, even it is to end up behind a glass window, next to the first Fisher-Price walking dog toy and a scary looking porcelain doll. I'd still rather play a skipping Sapphire that crashes after the first 5 minutes, while riding the dog and the doll on my lap, but YMMV.
Good luck.