At this point probably there's no room for another Playstation-style video game console. My friend who plays only console-style video games, the sort of person who owned Wii-U and an Xbox One as well as that generation of Playstation, bought a gaming PC last year. He will undoubtedly buy a Switch 2 at some point, to play a Zelda or something, but why would you buy another Xbox?
So I think Xbox becomes a brand for video games with Windows and then gradually it loses relevance until one day the question is "Why isn't Minecraft on Steam like a proper video game?"
According to leaks with an excellent track recordWe are getting at least 1 more console, and possibly 2. The first (most likely) is a classic Xbox, the second is a handheld. After that, who knows?
All I know is that I own both an Xbox Series X and a PS5. I use the PS5 more. I also own a PC, and it sees more than 1,000 times the usage of either. I bought the PS5 for exclusives, and Sony began changing that. However there are still alot of older PS4/PS5 titles that are fun to play, and some games are just better with a controller and a TV.
That being said, I'm likely not going to purchase any other consoles.