So UP is correct for a 3D game. However, the orientation of your objects need to be aligned correctly. I believe for a camera, it should be facing the negative Z axis (opposite the blue arrow). And any child objects, need to be at 0, 0, 0 rotations (like if you have a gimbal and the camera is inside that, the camera would be at 0 rotation and the gimbal can be rotated). If you are not using a gimbal, and are using Euler angles, then you need a gimbal.
https://kidscancode.org/godot_recipes/3d/camera_gimbal/
There are ways to make it work with a single gimbal and Euler, or no gimbals at all and Quaternions, but they are more advanced, and you should try to understand the tutorial I posted first before attempting anything more complex.