Both behaviors are trying to rotate the sprite towards their separate goals (Pathfinding towards the path, Turret towards the target), which causes them to conflict. You can circumvent this by having 2 sprites, one for the turret and one for the pathfinding. Stick the turret sprite to the pathfinding sprite (either with Pin behavior or events), this way the turret can turn towards targets and still move along with the pathfinding.
You can see an example of this in the RTS template example.