Does it affect the camera's turn/rotate (pan etc.), too?

The camera pan, no
Actually you create an orbit camera
you turn the pivot and the camera moves around the player
yes ,it can be de-attached