When I was a kid, Dave Berry had a column where he made fun of the US Strategic Helium Reserve. This taught me an important lesson: when people make fun of what seems like government waste, 75% of the time it turns out to be really important. Not always, but you should look into it more.
Given the contemporary examples, they weren’t wrong to think so. Everyone was trying to make a console in the 16/32-bit era.
Some of these are better than others–I’m fond of the PC Engine–but none can be called successful. Neo Geo is somewhat of an exception because it was used as arcade hardware. Some others here are the butt of jokes. There’s also a bunch of Japanese consoles around this time that go nowhere, and are little more than fodder for retro gaming YouTube channels.
Sony took a big gamble and won.