Given the memory quotes I received today, I'm going to upgrade to 128GB of DDR4-2933 (what the processor is designed for). This might shake up my benchmarks a bit. At the very least I'll be able to increase the number of compute kernels. My license currently allows up to 14.
This indeed seems to be the best course of action right now. With some CPUs there are issues running the fastest RAM bins (2933 MT/s JEDEC in your case) at max ram capacity (128GB) but judging by what's available online 10900K should do that just fine.
There seems to be little reason to use XMP with 128GB anyway as people seem to have
mixed experience with 3200 - 3600 MT/s being stable 24/7
Regarding new CPUs Intel has hybrid cores that will limit their usefulness and AMD has 2x physically spearate CCD dies above 8 cores as well (as explained above). Strix Halo could be an option but it's availability is a huge unknown on desktop (as it's a soldered BGA CPU foremost for laptops). It will probably be available in some mini-PCs early next year, but there are no guarantees.
Another interesting (though ultra expensive) choice is to go with Apple hardware (which to my knowledge supports Mathemathica well, though you need to double check if it works for all of your extensions).
Mac Studios have fast CPUs with unified on-die ram that has absurd amount of bandwidth for CPU standards (400GB/s for the base model 800GB/s for the M2 Ultra version) but even the cheapest 12-core variant with 64GB of RAM costs $2600. Upgrading to M2 Ultra is 4000$ and adding 192GB of ram pushes it to $5599. But these are also rumored to be upgraded to M4 versions soon. But this only matter if MacOS even works for you.
Going back to x86 land, Intel will upgrade their lineup soon, but it will still be with hybrid cores. The only other unified memory option, the spiritual successor to Strix Halo (AMD Medusa lineup) is still at least 1.5 years away.
So all in all, it might indeed be the best option to just upgrade the RAM and wait