I remember an early discussion with an engineer from either Smugmug or Dropbox, circa 2011-2012. Something like 99% of photos backed up online were pretty much never retrieved. I'd guess it's almost the same today.
More cynically, I wonder if that is why they don't give us the tools on our phone to easily prune our photo collections? Too much money being made in cloud storage.