In my company, 2 dataviz tools have been chosen: LookerStudio for everyone and day to day dashboarding. Tableau for advanced analytics.
We have one big project using Looker, and.... we are not really happy about the cost, the release management, the rookie style of the team....
+ Google promise us for many years to kill Looker. But it's still here.
The roadmap and strategy is not really clear, so not a safe bet for the future