The projectile usually hits the ground
underneath the player
Get Hit Result Under Cursor hits the floor - so you’re attempting to shoot at the floor. Either add Z offset to the hit location or use a method that does not revolve around getting hits from level geometry:
In your case you’d use 0,0,1 as Normal and place the plane at gun height.
But to be honest, it all depends how you want it to work. Do we always shoot at the same level? What if the enemy is higher / lower than us?