Streaming big-budget AAA console games is not possible as of now, maybe with 5G tech or beyond but right now, at least around the entire continental section of the US, streaming is not very reliable. It may be good for cities and certain special places but most of the country is still suffering from very low internet speeds and spotty service.
PlayStation Now would be a success by now if the internet service wouldn't be as bad as it is today. Even with some other problems like pricing and a thin library, video games require less lag, something that Netflix doesn't have to worry about.
Now, if PlayStation Now or this new Yeti program would allow people to download any of those games in their service and make them work on the system through emulation or native capabilities, that would be a totally different story.