This is not very realistic. Recordable and rewritable Blu-ray Discs are a much more consumer/prosumer-friendly backup solution, and yet, due to low demand, the market is slowly dying. The market size for prosumer tape drives would probably be even several times smaller.
I've never thought of (re)writable optical media for backups as having a particularly good user experience. I'm not saying tape is good or better but blu-ray is a lot of faffing about. In theory, the much larger capacity that tape can provide should reduce the faff factor, but the devil is in the details.