Sundar is good at keeping things running as-is.
He was elevated to CEO of Google to keep things running as-is while the founders moved their exciting ventures up to Alphabet. When those other bets were abandoned, Sundar was left as the top engaged executive, but he's still only a caretaker when the company needs an actual leader with vision to navigate their competition.
So, no. He has not been a good CEO. He was a good middle-manager and a decent CEO at best, but he's not been what the company needed, and he's definitely not what they need today.