Go on a number of the gaming subreddit and you’ll see Stadia is being met with distaste and hesitation. Gamers are increasingly tiring of the games-as-a-service model, and this is a step even further in that direction.
Personally I think this will have the same lifetime as a lot of other google products: it’ll launch, have some success, and then be killed unceremoniously a couple of years down the line.