I don't want the camera to rotate on it's own when the player gets on the rotating platform.

Camera Spring Arm
image

Camera
image

“Use Pawn Control Rotation” would stop it using relative rotation to pawn which cause them to rotate with pawn.