Well, you conveniently ignore the reality of lots of people who cannot afford or just don't want to buy a gaming computer or console there. Streaming services are an actual, viable option for them. Even though Google has done its best to show why it might not be just so viable after all...
Not having to keep up with hardware is pretty much the main selling point of games as a service and it's still not worth the tradeoffs.
I'm what they call a patient gamer anyway. I'm often 10 or 15 years behind, but I've never once run out of games to play and the savings are substantial.
Consoles (which have many of the same problems Stadia did) aren't usually terribly expensive if you're willing to be a generation behind and used console games are insanely cheap with the exception of certain franchises (Nintendo titles and JRPGs are notorious for staying expensive. Castlevania Symphony of the Night came out in 1997 and can still go for well over $100 for a copy!) but thankfully emulation covers a lot of that. By the time I picked up a PS3 I was picking up 10-15 games for the same cost as just one game at release.
As a bonus, waiting a few years to play the latest title means that everyone else has finished beta testing it for you and the entire experience is much improved. You can also usually get all (or most) the DLC included with the already low price of the game.
Point being, you don't have to spend a fortune or have a blazing fast video card to have a nearly endless selection of exceptional games.
You raise great points, but often a big motivator to play a specific game is the social aspect - playing with friends. Stadia gave me access to that when I wouldn't have otherwise. I have some really nice memories thanks to it.
Not to say I can't convince friends to replay older games - it's just a bit tougher.