Stadia was prepared for a future that was promised and not delivered on time: ubiquitous (mmWave) 5G.
A lot of folks point out that Stadia doesn't make sense because you'd be tied to locations with stable Internet. That wasn't suppose to be a problem anymore. Google misjudged the telcos who had promised 5G and delivered the weak, low coverage form we have today.
Had the gamble paid off, it would've been strategically perfect. Cloud-based intensive computing, which is exactly Google's forté, would've taken off and Stadia's infrastructure could've been extended beyond gaming. And the pitch would've been easy: don't buy $500 impossible-to-find consoles and $2k graphics cards. You'd also be able to play your games anywhere. Traveling for work? Log in and play on your crappy work laptop or Chromebook.