CD-R, and especially CD-RW variants, are not robust, and not a good archival form. CDs themselves are pretty good.

Vinyl, with some care for environment, is really good for archival.

Worth knowing most new vinyl records come with a copy of the digital download too.

Amazon will also automatically add (most?) vinyl purchases to your Amazon Music Library, and allow download.