Tapes are waaaaaay to expensive for ordinary ppl. You can't even afford to buy the device (there are only enterprise devices now).

Spinning disk, might be. Store the data, put it into a freezer (or other dry place), don't spinn it too much.

ssds are fine. if you dont write often it will outlive you. Just buy two or three from different manufacturers and replicate the backups

btw. the truth is that you'll never be able to get your data because you're probably doing your backups wrong 🤪