It’s just a different perspective

Most people that wouldn’t use inverted y axis for a mouse or joystick controller would fly a plane with a yoke “inverted”. Back goes up, forward goes down.

It’s easier to imagine sitting in a plane

Like it’s easier to imagine controlling a character on a screen if you were sitting in their head with a plane yoke to control. In that case it would be inverted.

Anyone can learn to use inverted y controls. Just it’s not the default everyone learns so it’s not “normal”