Hey @RHIJZY
You can lock rotation and movement axis.
Select the SkeletalMesh, StaticMesh, Capsule or whatever your root component is, and modify its constraints.
You can also break the rotator calculated by Find Look At Rotation and set the Yaw to 0 before setting the new rotation.