What I don't understand is how this will work with every game automatically? Wouldn't this need support from the graphics pipelines in each games?

You're thinking about foviated rendering. They're just doing foviated streaming. So it renders at full resolution, and only streams the parts that you're looking at with full resolution on the stream.