Wow nice! I had some HDDs , some of them were alive till 10 years but not much longer.
I'm amazed that with all these technologies we haven't figured out how to store data long term (atleast couple decades) without changing the underlying components. Like you said tape drives aren't for end users.Also with how technology is evolving (fast and disorganised) I'm not even sure if you would be able read a drive in 20 years. Very tech is that backward compatible.
The good thing is that 10 years later you need less HDDs of larger capacity to move your data to. And they tend to be cheaper. So every 10 years you move the data to a new set of disks, works good enough for most people. I did it a few weeks ago, it took ~ 8 hours over 10 Gbps Ethernet.
It is not necessarily bad we don't have a very long term storage solution. Imagine you took backups on 360kb FDD 40 years ago, you were drastically limited on how much data you could store and if we assume you had 1 GB of data back then, that is a huge pile of floppy disks to copy at very slow speed. Now imagine you have 10 TB of data today and that will be a tiny fraction of a microSD in 40 years, but reading your 10 TB from HDD will be painfully slow in the year 2065. At the same time if you replace the storage medium every 10 years you keep up better with capacity and performance.