No doubt, AMD's Threadripper 3900X isn't a CPU for the average mainstream desktop user
The 3900x is not a threadripper part... it's a 12 core high end consumer grade part. This is a slight oversight by the person writing the article summary and should be corrected.
There is a general positive correlation between a processor's efficiency and how specialized its function is. Human brains are highly adaptable (at least compared to a modern CPU), and can do a wide variety of tasks, but most of them very slowly. This is why we are perfectly capable of doing basic calculations by hand, but we prefer to have a calculator handy. A CPU is a lot more specialized in that it has a limited set of operations it will be required to perform (the x86_64 instruction set for example). It's still not extremely specialized, but at least it doesn't have to dynamically implement new operations, so it can do many tasks much faster than a neural network. However, a CPU is still too slow when it comes to keeping up with all of the floating point calculations required to power our modern graphics. The CPU's time is too valuable, so we give the CPU its very own calculator AKA a GPU... this calculator has an even smaller number of operations that it can do and it has many parallel channels in which these operations can be performed independently. Now instead of the CPU wasting away doing all of these calculations itself, it just offloads them to the GPU, a more specialized processor.
ASICs (application specific integrated circuits) are the next step in this hierarchy. They have no adaptability beyond what was designed into their circuitry (application specific), which makes them extremely good at exactly one thing... the thing they were designed to do. Because logic is implemented entirely in hardware, there is no constant running back and forth between caches or waiting for a central processor to choose a branch in an 'if' statement or to exit a loop. It's the perfect hardware pipeline. Because there is so little dependency on outside resources, ASICs are inherently highly parallelizable, so you can run very large numbers of them side by side. The bottlenecks of an array of ASICs are mainly how fast you can give them input and how fast you can process their output. This makes them perfectly suited for things like computing hashes for crypto-currency mining.
"An ounce of prevention is worth a ton of code." -- an anonymous programmer