After reviewing the project, it appears that adding a new camera component to a character has the “Use Pawn Control Rotation” boolean set to false by default. This may be why the Y axis was not working initially for you. Setting up the MouseY input as you described and checking this checkbox for your camera component on a newly added camera should be all that is required for your LookUp to function as expected.
Cheers