I don't know anything about Cinebench R23, but according to wikichip, the max clock for an i9-7980 XE (with all 18 cores pegged) is 3.4 Ghz, so that cinebench result (assuming Haz123 is referring to the same source as I) looks too high.
I can't find any review sources, I think because R23 is too new and wasn't used with older CPUs, but Nanoreview (never heard of it) puts the i9-7980 XE in the region of a 10900K (17.5 - 18K), which is 8 cores down, but has a massively higher boost clock.
Yeah the 28k score is most likely the world record with the cpu under LN2 so not really a comparative score to an average 7980XE system and the sub 18k score does make more sense. My fault for thinking it was a normal score. What that all means is the cpu is working just fine and within expectations.
This leads us back to the original question and whether an upgrade is a good idea. One option is to just get the best and go for AM5 7950X 32gb DDR5 and X670 mobo but that is close to £1500. Other options are relevant but that is the only one that will give a large uplift in both productivety and gaming.
Is very difficult to advise when productivety tasks are involved because there can be very large variations in results. For instance , your 7980XE on the HEDT platform with quad channel memory and supports AVX512, not all cpus over the past 5 years has AVX512 support so if the software you use utilizes AVX512 the performance uplift with cpus with it supported is massive.
Search for benchmarks with your most used programmes is a good idea. There may be surprising results.