The camera rotates on its own when the player gets on the rotating platform. I want the camera to stay still unless the user want to move it. It should not move on its own just because the character is on the rotating platform
Try making the rotation binding absolute for the camera, or a spring arm if the camera is attached to it.

Or in the default component settings.

Camera Spring Arm

Camera

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