As a product I agree Stadia was dead on arrival, there was no chance people were going to buy games again on a brand new platform at full price with the potential for a poor experience every time your wifi flaked a bit.
The tech behind it though I find fascinating. I would love to have the ability to stream my games to a chromecast that I can attach to my TV downstairs, or take with me travelling. Most of the games I play aren't fast paced so the odd latency blip for the convenience wouldn't bother me personally.
I think the way google should have played it is gotten into bed with Valve. I feel like there is a market fit for steam link without the local streaming faff. Use google's infrastructure to stream your back catalogue of steam games for $XX/month, maybe throw in the odd free game like the game pass and I can see it gaining some traction. Certainly it would have more chance of success than going in to a mature market solo.