But still, they could have soldered 32 gb on.
The real limitation IMHO is power: to chase thinness, they reduced the battery volume and went for all the low-power options they could find. 32gb would likely not be low-power.
I can do that easily on my 24GB imac. If that starts to get cramped, I can upgrade it up to 64GB. But I would be SOL on a 16GB macbook pro
(Some of this probably comes from the fact I cut my teeth on machines with 64K RAM... but once machines got past half a gig, the availability of RAM seems to have outpaced the need, at least for me.)
Moving things in the cloud isn't an option, thanks to internet being too slow and unreliable, and I don't want to be tied to a desktop.
For "actual [computational] work", use a different computer suited for the purpose, not toys marketed to graphics professionals and hipsters.