Google has had a long history of messing up on the content front. They've made a lot of false starts with Youtube to get into paid content and it just never took off. Netflix is raking in billions from paid subscriptions. Not so much with Youtube. Few people pay for the premium content because there hardly is any worth paying for.
Where Apple TV, Amazon Prime, Netflix and others succeeded, Google failed repeatedly to get a compelling offering of content together. It's a blind spot they have; they seem unable to come up with a coherent plan. They can do the tech but not the content. I'm not sure what it is. On paper the tech is a lot harder and they do have deep pockets. But when it comes to content they are a combination of stupid and frugal and somehow refuse to spend money on good content to lure in customers.
With Stadia, they had the right idea and all they would have had to do was two things: fix the bugs and get some amazing games in there. They dropped the ball on both fronts. So, it failed because they never gave it a proper chance to begin with.