The part is intended more for bragging rights than as something for people to actually buy, so most of the usual sites won't have a review. If you want a review, here's one:https://www.anandtech.com/show/13748/the-intel-xeon-w-3175x-review-28-unlocked-cores-2999-usd
Basically, Intel took their top of the line Xeon Platinum 8180 28-core server CPU and made an HEDT processor for consumers out of it. They won't sell it directly to the public at retail like most consumer CPUs, but only directly through system integrators. For example, from Maingear, it starts at $14,899 and goes up from there if you want any extra options:https://www.maingear.com/boutique/pc/configurePrd.asp?idproduct=3149
Rumors are that Intel is only going to sell 1500 of these in total, so there isn't going to be much of an ecosystem for it. There will only be one CPU for the socket ever, and possibly only one motherboard because of the very low volumes involved. The CPU can pull over 300 W at stock speeds, and much, much more if you overclock it. If you've ever wanted to pull more than 1000 W from a CPU without liquid nitrogen, this is a likely candidate if you can get a beefy enough water chiller and a huge overclock.
This is the current top of the line HEDT (high end desktop) processor, but it won't remain that way for long. Once Threadripper 3 comes along, likely later this year, this is going to feel really dated.
So why does it even exist? So that Intel can claim that they have the top of the line HEDT processor for a brief period of time before they get overwhelmed by AMD's 7 nm lineup. Intel will remain competitive on mainstream desktops for quite some time to come, as if you don't have very many cores, you can clock them really high and get good performance. Try to do that with a lot of cores and you'll have some pretty severe heat problems, which is why Intel won't be able to compete in that market again at least until they move to 10 nm, if not 7 nm.