Externally, companies like Spotify and Kabam Games rely heavily on BigQuery as well:
https://www.youtube.com/watch?v=LTVFg6YOjWo&list=PLIivdWyY5s...
https://www.youtube.com/watch?v=6Nv18xmJirs&list=PLIivdWyY5s...
So the story of Google Cloud products, which are paid, supported, and Enterprise-grade, and which are covered by a clear 1 year deprecation policy, are very different from the story of free services.
Public Datasets is just a function of BigQuery's unique ACL functionality.