@Archie8 My biggest part of my collection are vinyl, followed by CD, then cassette. Vinyl will outlast the rest, but if taken care of, CD rot can be prevented, or at least slowed down by a lot.
I also rip all CDs to digital file, then move the files to new hard drives every 3 to 5 years. I still have mp3s from the mid 90s XD