No, that’s insanity.
TBH, pursuing this type of nerdery is just wasting time to excuse not curating stuff.
All electronic media is bad for long term archiving. People who restore things for a living over a period of many years transition media regularly.
You presume the things I want to save aren't individually TiBs in size.
Anyone who has even an amateur interest in, say, making movies, probably has at least a few projects worth of 4K RAW footage they would hope outlives them. (And the average small-time YouTube content creator has far more.)
Using LTO specifically for the purpose it was designed for is the exact opposite of insanity.
This has little to do with whether you curate. That's a whole different discussion about optimizing for cost, where many many terabytes eventually make LTO become cheaper. When we're specifically looking at reliability for important files, there might only be one tape's worth of data. It's a $3000 fee to make that tape (and its backups) last a long time in storage, and having more or less data barely affects the price.