Most of all, investors wanted clarity on spending, and Google reacted with the restructuring.
Let's take a moment to fairly summarize what's happened: extremely risky ideas that no sane investor would fund, received disproportionate funding, and as far as I can tell, they all failed even after a decade+ of not expecting profitability. There's no reason to pin this on Sundar - the ideas failed on merit
Also, speaking honestly, he's been rather generous with many projects (Chrome OS and related hardware, Stadia, even horribly performing pixel phone sales), despite decades of losing billions for Google.