In your first setup
before cast to rocket launcher use Get Owner, cast owner to rocket launcher, and move Destroy Actor to the end.