Y-up originates from high school math working with 2D graphs where Y is vertical and X is horizontal.
Z-up originates from the concept of making sense
Went z-up in Maya, never going back. You can group Y-up with the other failed standards such as 29.97 frame rate that came about after the black and white era ended, call it a lack of foresight 
Y-up is more common in film because it’s been the standard for reasons listed since forever, Z-up is more common in games because making sense actually matters a lot more when you can’t mostly ignore the axis system to the extent that a significant amount of artists aren’t aware of the differences between euler and quaternion rotations or how the axis system works.