How do I use AimOffset like this?

Yes

basically the turn in place animation which occurs at specific yaw values of aimoffset still allow for the character to move at any point without snapping to the forward direction but the weapon will always hit the crosshair if there is no weapon spread