Fiber rollout is increasing and Starlink can offer 20ms under good conditions right now and it or competing networks can get lower still.
A hybrid console is also possible it will have enough horse power to run “casual” games but if you want the top tier you’ll have to stream.
Console makers usually don’t make money on hardware so if they can move everyone off it and just stream that’s a no brainer for them.