My day job (company died a couple of weeks ago). We had > 100,000 LTO tapes in the end. With data archived way back in 2002 until present. We were still regularly restoring data. In our busiest years we were doing what averaged to 177 restores per day (365 days a year). Barely any physically destroyed tapes.

I see a few articles citing robotic failures as a big issue, but really someone can just place a tape in the robot if critical recovery is needed and the robot has died.