Niagara emitter update problem

but the actor rocket you use, SHOULD be the rocket mesh, place the emitter at the rear of the rocket and generate flames trails
you are spawning a STILL particle once every lifecycle of the emitter
which drops each time it spawns

remove the rocket emitter, add mesh to the actor, use only tails/flames for the rocket in the Niagara system

All you are doing is spawning a new rocket every time the niagara system timeline restarts, as there is no velocity it stays put
you are already moving the rocket actor, use the mesh on there its so much easier