Stadia is already out of the window because you can't hear anything about it and I think the general public will find the Playstation 4 and Xbox both better than Stadia in this decade as well
The idea in itself isn't bad.
But Google doesn't seem to have given enough thought to how bad the internet is in many first world countries.
While everyone in Silicon Valley has a fiber optic connection, there are still people in Germany who don't even have DSL.
Yes, unfortunately, Highspeed has not yet arrived in Germany
But I also find the idea really strange to only rent the games when the subscription expires, you don't even have any game CDs for your money that are left over, that's a bit "cheap".
You don't do anything else with Playstation Plus. If your subscription is gone, you can forget a COD or Overwatch.
With a subscription yes, but you keep the games you bought and they are not gone if you no longer pay for the subscription