Well yeah, you don’t set the projectile direction, of course it’s not going where you want it to go. In your setup the projectile direction totally depends on the SpawnPoint rotation, and since that’s attached to the gun, so on the gun rotation, and it fires exactly where the gun is pointed.
In the Spawn Projectile node: clear the Spawn Transform pin, right click it and Split it. Do the Same with the GetWorldTransform. Connect Location and Scale to each other, but as for Rotation, Get Character’s Rotation. Thus you’ll make the projectile shoot straight where the character is looking.