But spline can only control the
movement of my character position, but
it has little effect on rotation
You must be getting close. This is because the pawn still controls the camera boom’s rotation and most likely simply overrides it. Consider switching it off for the duration of camera transition. Camera Boom → Use Pawn Control Rotation {F}