Sure, but the Mac Pro has always been like that. There was a wide gulf between the 32gb base mac pro and the 1.5TB version too. They've always covered from high end amateur to high end pro.

I think that's the point though, they're catering to the kinds of producer/professional that you list AND people who might want to do something that might need all that memory (there are plenty of scientific and AI workloads could easily chew through that)

Apple is also in the situation where as a business they will want to gain OS market share, but without the advantage of the PC platform that anyone can build a PC to meet their exact needs. If they're hypothetically incredibly successful at their goal but with just consumer targeting hardware available, they're leaving market share on the table by not providing hardware to fill the more niche use cases.

Now they could have done the provide loads of options thing, but it's Apple, so they do their normal thing and have basically this one configurable model to serve all the possible non-average-consumers who want a workstation out there