I don't see tape being killed off until magnetic density in HDDs hits major diminishing returns. Even though there is only one tape drive maker these days (Quantum with the LTO line), they can keep advancing tape because the media has a lot more area than a HDD platter (or a stack of platters.) An average LTO-6 tape is 846 meters long, and that is a lot of space, even with factoring in the physical contact that the media has to go through.
It would be nice to see a consumer grade tape drive that can run from USB 3 or 3.1, especially if WORM cartridges were available, with media about 1TB native in capacity. Couple this with some decent backup software, and it would come in handy to mitigate data loss. Tape's advantage is that it is inexpensive, easily stored (drop a cartridge, and if there is no physical damage, it will still work), and can be set read-only in hardware.
I've wondered if a HDD maker could make archival grade hard disks, with media that can last 25 years or so. This might require multiple sets of read/write heads (similar to a drive that had two sets and could access different data sets at the same time independantly.) Couple that with a form factor that is easily grippable/manipulable by a robot, and that would replace both VTLs and real tape libraries.