As Stephen says,
it looks like your emitter position is the problem. The emitter position is where on the object the bullet will shoot from.
Since in your case, it looks like the bullet is very close to the ground, when you have destroy on impact on, it destroys immediately because it's hitting the ground right away.
You can enter values manually from the shoot behaviour properties, or you can tap the object graphic from the behaviour properties and move the blue target to the location you want the bullet to shoot from.
https://hyperpad.zendesk.com/hc/en-us/articles/115000898946-Shoot-with-Button