You need to set the cursor hotspot. Set the “x” coordinate to half the width of your texture I think? Experiment with it until it looks right.
The reason it looks right sometimes is similar to the reason a broken clock looks right twice a day: that axis just lines up with the default hotspot such that the projectile also goes through the center of the cursor.