The motherboard should support up to 12TB ram.
And it's a plain regular HP ProLiant server, so it's not going to give you any hassle when running Linux. Heck, some distributions (likely RHEL or SuSe) might even be certified for use on that platform.
So to sum up: for people with money and wanting to play on large-ish datasets, a second hand mac pro is really a poor choice on how to spend their money.
Note: i didn't even look that hard for a better offer or a better-priced listing.
But yes - good luck selling a 1.5TB Mac to anyone not doing video production (and depending on the platform) for anything remotely close to retail prices.
Apple probably realized they only sold approximately three fully configured machines and decided 192GB should be enough for anyone.
Only if more than a tiny sliver of the resale market for that product is for VisionOS development (a market segment that does not yet really exist).