Tape backup technology has been around for decades and it still remains a viable option for data storage, especially for long-term archival purposes. The lifespan of tapes can vary depending on usage/storage conditions but generally they can last up to 30 years or more with proper handling/maintenance.
Regarding drive compatibility, most tape drives come with drivers that are compatible across multiple operating systems including Linux and Windows 10 . However, it's important to check manufacturer specifications before purchasing any hardware to ensure the desired level of compatibility exists between hardware/OS/software versions being used .
SSD prices have been dropping rapidly over the past few years making them an increasingly attractive alternative to traditional mechanical hard drives (HDDs) in terms of speed/reliability while offering lower power consumption/noise levels. Depending upon capacity requirements , SSDs may be cost effective solution compared to Tape Drives as well provided backups don't require very large amounts of space which could make Tape Drive more economical.
It's difficult predict exact timeframe when SSD will become same price per TB as Tapes since pricing factors depend upon market demand/supply along with production costs associated with each technology - however based on current trends we might see parity within next few years given how fast SSD prices are falling.
In summary , if you require long term archival capabilities then LTO-5 tape drive is good investment providing reliable and relatively low-cost storage medium suitable for safekeeping critical data assets . If your use case requires frequent backups then consider investing in high-capacity SSDs instead which offer faster performance/reliability albeit at higher cost points than tapes.