I'd be concerned about it's performance as a good all-around computer.
I believe the Apple Silicon Macs are some of the best all-around computers you can buy. They are unusually well balanced in terms of 'system performance' if we look at CPU power, SSD speeds, memory and 'utility GPU'.
I think its weaknesses lie in areas where you'd want a strong dGPU: gaming, GPU rendering, and heavy video work (high res debayering, multi-node effects, or beauty work....).
Plus, most people will want to extend disk space. One large external drive is OK, I think. But if you want a large HDD raid + an external "cheaper" SSD + a few other things.... then it gets messy.
If you're a gamer, this is likely not your computer. But there are so many areas of computer work where these Mac Studios will be very popular; general office work, design, photography, software development... I also think we'll see them show up "everywhere" on larger productions as 'video render cows' due to their unique power to size ratio. On other forums, I see interest in adding one of these in addition to a classical workstation, due to its strengths in encoding and small size.
The Mac Pro is not only upgradable - it's also flexible
Being an owner of a 2019 Mac Pro, it has been interesting to see the new generation of Macs unfold. There are many areas now where much cheaper computers outperform my Mac Pro in single metrics. If we're being honest, the 7.1 Mac Pro was built on yesterday's technologies.
When I picked mine up (used), I was well aware of where the tracks end. But I also knew that I will be able to keep upgrading it by picking up previously high-end parts when the prices come down; I haven't done the CPU upgrade yet, but it's coming closer (targeting 28 cores for $1000).
I'll have to wait and see what happens to MPX modules. I haven't really seen any top components in any bargain bins, so far.
Overall, I prefer to look at it this way:
know your needs. If you do, I think you'll likely find a Mac for you somewhere in the range—for work.
I guess gamers are the exception. It's a pretty large community that helps drive hardware development. They remain dependent on dGPUs.
And we already know that Apple is making a new Mac Pro as well, so I think it's all good.