On the biggest end, you have folks like AWS glacier with an absurd amount of homemade libraries (and generally no tapes stored on/off-site outside of libraries)
IIRC Facebook actually built something similar for their cold storage.
At least that was the case at a place I worked ~5 years ago.
Once you've invested in the initial infrastructure (drives, libraries), the incremental cost of extra tapes isn't that much, so you can keep things on the shelf for a long time for not a lot of money.
Send to two tapes for resiliency and every few years to a tape-to-tape copy to stay on the latest hardware. LTO drives can read two generations back: the just-released LTO-9 stuff can read LTO-7 tapes, and also write LTO-8.
Though a lot of backup software supports S3 APIs, so some folks are sending (encrypted) bits to Amazon Glacier (Deep Archive) since they practically will never have to retrieve it.
Its a good way to move entire shows to and from online storage. Its effectily a one off cost, vs a continuous cost for power and cooling. Its also a fast way to move data from one company to another. a ten drive robot is many times faster than 10gig ethernet.
For other companies its attractive because tape is literally offline. Once its out of the robot, there is no automatic way to get it online again. This means that its far harder to tamper with.
It’s a pretty great fit for the technology. You keep the most recent data on hard drives for analysis, and as new data comes online, the old data goes to tape. You don’t want to get rid of the old data, of course, because you need it for analysis verification and when people come up with new analysis ideas, but the older data naturally gets accessed less and less as time goes on, making tape storage a natural choice.