ex-googler here.
The average Googler hated how many good products were killed. Many want to continue/improve many of the (countless) products that were sunset. I'm sure memegen is on fire as we speak and how Google should be and do better.
Sadly, that's not how it works in a corporate. At least not at Google.
If your boss moves you off the project and hands you new work, that's how it is. You need to spend ~8hrs/day on your next project. Doesn't leave you with any time to work on that project you know is being sunset, and definitely won't help with your Perf and yearly bonus.
Many products have like 2-3 people keeping the lights on for months before eventually the plug is pulled. This rarely happens overnight -- the teams have been moved/offboarded months ago, working on other higher priority stuff.
I don't know how it was for Stadia though -- but I assume it was the same.