I don’t think bit rot will affect all cds. And actually I don’t think bit rot is technically even the correct word to use for cds.
As I understand it, bit rot refers to the eventual loss of data in an eprom. This happens when data, which exists as stored electric charges (each charge represents a bit) eventually fades away over time. The point to be made is that the physical chip material isn’t failing, it’s just a loss of electrical charge.
With cds, what actually happens is failure of the material. The material in the cd itself actually decomposes. But I don’t think this happens at the same rate for all cds. CDs have varying levels of manufacture quality. Also some cds have more protective layers than others to better insulate the data layer from being affected by oxidation. I imagine that some of the sturdier cds will keep going and going.