The rotation of the missile is not set by the missile, it is set by the spawner(turret). Put the find look at rotation from your missile to your turret bp, and attach it to the spawn actor, right click on the transform and press the split struct, then attach it to the rotation.
For the collision problem, your collision component is changing location and teleporting somewhere else. Delete the collision sphere in the graph as target, so it becomes “self”