In reality, people much prefer local latency-free gaming and use game streaming as a last resort. I got the free Stadia kit with Cyberpunk 2077 purchase and it was neat the first few times but haven't touched it since. For people that don't want to invest in a gaming console or PC it's a good choice though.
I said future for a reason.
Latency is something that will improve in time and less and less users will care/notice in time.
Most people don't buy gaming PCs, and the console makers are heading in this direction for a lot of back catalog as well.
Sure this will never be everything for everyone, but the number of people it will be enough for is only set to expand in time.