There are still processes that benefit greatly from cpu advances. Something like compiling code, for instance. But even if this were the case, high end cpus like these can now be used with several gpus where a lesser cpu might be able to only feed n-1 gpus. Density is pretty important in data centers and elsewhere. Think ML researcher with 4 big gpus in their desktop
There are lots of random bits which are still CPU bound.
https://www.pugetsystems.com/solutions/ - can you click through to workflows to specific programs and then look up Hardware Recommendations to get a run down.
While Blender itself is a mostly GPU bound situation, a lot of other media creation software is more mixed.
* Photoshop: mostly still limited to 8 cores (some filters being GPU enabled)
* Premiere: GPU used only to handle specific effects (so it depends on your mix of effects)
