Of the first five SSDs I bought, going on 8 years ago, 2 have died outright, and others started throwing errors so I nipped them in the bud and replaced them.

SMART can give you clues and reviewing their use logs can let you plan. Just sayin'...

Tape is almost forever, magnetic spinners are very durable, SSD is deliriously fast and potentially short-lived. Even with a system optimized to minimize SSD write operations through proper caching, SSD writes are a known finite quantity. For now, at least.