I have been using GCP/BQ heavily for 7+ years now and we're GCP native at my current company for nearly 5 years.
Google's penchant for deprecating products is a constant worry for me, particularly our insane reliance on BQ. While BQ StandardSQL is close enough, lifting and shifting to something like AWS or Azure's cloud warehouse tooling would definitely be a headache.
That said, with their deep integration w/GA4 reporting and continued development of BQ, I am guessing they make enough money (particularly after their 25% price increase for on-demand) that it'll stay around for another few years.
Fingers crossed because, honestly, I don't want to have to deal with management of our warehouse and BQ makes it easy for us not to worry about that at all.