Frankly I'm surprised how many other systems are Z-up.
Right-handed Z-up is the default orientation in mathematics and related disciplines (like physics) when working with 3D Cartesian coordinates, which I guess is why most of the software in that quadrant is used for modelling real-world objects (compared to digital-only game assets etc).
As far as I can tell, it's more about what the final output is used for. If it's to be rendered on a screen, then the convention is that the z-axis is depth (since the x-y plane represent the location on-screen). So game assets and VFX tend to prefer Y-up. If it's a digital representation of a real object (like in CAD programs), then the more "physical" convention is the useful one.