It could in theory have solved the Xbox problem of: every time I want to play a game the console insists on downloading 20GB of updates from Xbox Live, which appears to be capped at 50MBit/sec on a good day, thus wasting all the time I had available for actually playing something.
Technologically, the model of subsidizing consoles to put great hardware in your living room for not much money is a good one. You get ultra-low latency, games can work offline if need be, the experience is predictable and robust once installed and you can actually own the games. In practice it requires a willingness to commit to big expensive CDNs, download optimization, and smooth updates that Microsoft just don't seem willing to make. Streaming would appear to fix that regardless of other merits.
That said, I never looked at Stadia. We (me+fiancé) just don't play enough games to warrant changing anything right now, and we tend to pick the platform based on the game not the other way around.