Hi there,
Have you tried setting 'Use Pawn Control Rotation" to true on your Aiming Camera? That variable tells cameras (and spring arm components too!) to use the rotation of your player controller so it should rotate correctly.
Here’s an image of where it’s located when you have the camera component selected.
I hope that helps!