CDrs still are a thing, and may work "about as well".
The only surefire way for long term archival storage for the average user is to use multiple methods, and check them from time to time.
It's all a matter of cost vs how much you want to archive. If it's in the "CDr size" you can just make tons of copies, some will probably survive.
But you can also just keep that much around on every device you own and checksum it regularly.
Tape is pretty good, but even there you'd want multiple copies on different media. You could rent a drive or buy a used one, write out your tapes, and then sell the drive again.
Hard drives sitting unpowered have a "decent" change of firing back up after 10+ years, if you have the connector (externals are probably easiest) - but even there I'd want multiple copies from different vendors.