IMHO it wasn't just Google (and if then only in the sense that they picked the wrong people), Stadia was lead by an "old guard" from the traditional game console business (and weren't even particularly successful there). Trying to shoehorn the console business model into a streaming service is essentially like trying to create an awesome technology for streaming movies, but then still forcing people to buy movie tickets and go to the cinema for watching those streamed movies.