I have CDs that are 30-40 years old and play just fine. CD-Rs may have more issues (though all my 20-year old burned discs still play), but commercial discs can last a long time if you keep them in a case of some kind and don't leave them in humid conditions. They probably won't last centuries, but I expect most of my CDs will probably outlive me.