Depends on what you mean by fragile. CDs are really susceptible to bitrot
https://en.wikipedia.org/wiki/Disc_rot
Archival discs are made with gold backing, which is much more robust than the aluminum reflector used in mass-pressed discs.
IME that's mostly a problem with self-recorded disks while pressed discs are quite durable in practice. Maybe if you keep them in a very humid/hot environment you get different results.
> CDs are really susceptible to bitrot
Define "really susceptible"? I've bought hundreds of albums on CD over the last four decades, and only one of them has ever gone bad on me.
The first CD I ever purchased, manufactured in 1990, still sounds as good as the day I bought it.