From reviews I have seen on the X3D feature, it is basically just additional cache on-chip which can assist "small" CPU workloads which require frequent cache transfers quickly - this benefits (some) games which rapidly load/unload relatively small bits of memory but is not ideal for large dataset workloads like PixInsight.
For software like PixInsight, where you may be processing 100's of GBs of data between CPU, RAM, and SSD (e.g. when stacking), the X3D stuff doesn't really assist much. I've also seen reviewers mention the algorithm that controls the X3D cache sometimes does wonky things especially in benchmarks, sometimes choosing the wrong (slower) cache and actually hurting results.
The things that benefit PixInsight the most: A very fast (and large capacity) SSD, as many CPU cores as practical (hence why the 5900X, 5950X, and 7950X benchmark so well), and a reasonable amount of high speed RAM (DDR4 or DDR5, minimum of 32-64GB). For processes such as RC Astro's plugins (BlurXterminator, StarXterminator etc) and starnet 2 which benefit from CUDA acceleration, get a decent GPU like an RTX 3080, 3090, 4080, 4090 etc.
I would honestly stick with the 7950X or even save some money and get the 5950X.
For what it's worth, I run a 2TB 980 Pro M.2 SSD, 5900X with 64GB of Corsair DDR4 3600MHz RAM, and a RTX 3090 with the CUDA acceleration stuff set up to improve CUDA accelerated processes in PixInsight. This is already "not the fastest configuration" with the new 7950X and 6000MHz DDR5 RAM now on the market, however, I do not feel like I need anything faster at the moment. This system is plenty fast enough for me.
Some of the benchmarks you are seeing in the PixInsight benchmarks that use large amounts of RAM are configuring it as a RAM disk - I personally do not see the need to do this as M.2 storage has become so fast now and is cheaper than RAM per GB.
Also, look into
adding multiple temp file SWAP directories - I added 8x duplicate temp SWAP directories and improved my benchmark scores significantly.