One good reason is that a huge population of companies just don't have enough data to justify Snowflake. We sell a product built on it, and I wish we'd had DuckDB 3-4 years ago; it's perfect for 95%+ of our clients
In that case BigQuery is more managed than both, PAYG for analytical queries without thinking about compute nor clusters whatsoever.