The spec still uses letters, WiFi 7 is 802.11BE under the old common name convention this gen would be WiFi BE which is a bit confusing. As of WiFi AX(6) they switched to numbers for the common name.
As for who it's good for, it's great for everyone, not just gamers. The spec has a lot of major improvements in bandwidth, collision avoidance and transmission density. All of which makes it better to move lots of data to multiple clients at the same time. Meaning if you wanted to stream Netflix to 3-4 devices in 4k the limiting factor is not the WiFi anymore, it's the internet connection and the client hardware. If you work from home and have to video call in, but others in your house want to stream high bandwidth content, no problem.