I doubt that Google will pull this off. Not because of the product, but because of their corporate culture. The reason Google has so many failed/discontinued projects is because they consider themselves a bottom-up company*. Small teams compete against each other for the attention of the higher ups. Each team comes up with its own projects fairly autonomously without external interference. Once in a while one of those projects looks promising enough to get some support from the top brass. But if the project runs into problems, as almost any project does, it can't expect much support because there's a trillion other projects vying for attention and resources. If you don't knock it out of the park within the first two or three years, they'll demote you back to company-internal toy building and give somebody else some time in the limelight. The only exception I know of is Google Glass, which had huge media buzz for years and hence was kept around despite enormous problems. Game streaming is not nearly as futuristic a concept as augmented reality, so I don't think Stadia will have much staying power if it doesn't make a huge splash right away --- which is a tall order considering that even mass market consoles with brand recognition can take years to really penetrate the market.
*This is a huge difference to the top-down culture of Microsoft: management decides the long-term plans, they allocate teams and resources to those plans, and they stick to those plans (partially due to the vanity of the managers who decided on those plans). Even money sinks like the first Xbox are acceptable if there's long-term potential. Even an unmitigated disaster like the Zune got 6 years to turn things around.
*This is a huge difference to the top-down culture of Microsoft: management decides the long-term plans, they allocate teams and resources to those plans, and they stick to those plans (partially due to the vanity of the managers who decided on those plans). Even money sinks like the first Xbox are acceptable if there's long-term potential. Even an unmitigated disaster like the Zune got 6 years to turn things around.