Console gamers already have consoles to play games on. PC gamers already have PCs to play games on. The Gen Z generation play games on their mobile phones. What happened is that Google thought there were huge amounts of people out there that so badly wanted to play games, but couldn't because they can't afford the hardware, that they would flock to Stadia as their first gaming platform.

Those people don't exist in any significant numbers.

Every self-identifying gamer (me included) knew this service was DoA.