With Google's reputation of killing products, and the hubris of thinking they could just waltz into the gaming space and be competitive within a year, it's no wonder that no one took them seriously and the product never took off.
Other streaming services like GeForce Now (sp?) let you install games you already own on Steam and play them on a cloud computer, which is a much more attractive model I think.
I wonder if they tried the subscription thing first but then gave up and just went with the buy model as a least-worst choice at a point in the cycle where it was too late to back out of the whole endeavour.
Stadia uses custom hardware so games can't just run on Stadia as-is, they have to be ported, which requires investment from the game's developers (or a porting shop).
I have to imagine most publishers that Google approached expected them to foot some of the bill for that work, if not all of it.
They should have gone with standard hardware basically.