Let's start with the target audience. Who is this product for?
Low-income consumers? Not really... when games discounted on other systems are vendor locked $59,99.
They're better off buying used games or simply using Steam or any other PC storefront. Plus you need a number
of devices (phone, Chromecast, TV) etc. to get this thing to work in the first place.
High-end users or enthusiasts?
Stadia games perform worse than Xbox One X and PS4 Pro. Nor are there any noticable exclusives.
If you invest in a 4K TV you will just pick-up a console or hook up your high-end PC.
This looks like a product conceived in a boardroom and no one dared to ask "Why are we making this?" or "Who is this for?"
Unless Google figures out a 'hook' it'll die within months not years.