That's the problem, tape isn't going anywhere. A decade back, it boasted a huge capacity advantage. Now with all the newer tech, the spinning media storage advantages, etc, it can barely hold a big drives worth of data. And the tape drives are expensive... Lto7 should hold like 50T on a this and dollar tape drive to look really interesting again.
It's true for sufficiently large values of “at scale” but tape has uniquely high overhead costs – hardware, software, staffing – which have to be balanced out by those lower storage costs. HDD/SSD costs have been declining at a much faster rate so we're already at the point where only the largest storage consumers are going to reach the point where they see a return from the initial investment in tape.
That is likely to be cheaper than a 16 TB SSD for a very long time to come. Tapes aren't going anywhere.