Place it just before the reveal in an edit, with a pew pew first to signal the launch and a vine boom right after it for the impact, so the sequence builds from shot to pass to hit.
About this sound
The Missile Flyby clip is a one-second sound effect of a missile rushing past at high speed, with a sharp whoosh. It feels tense and sudden, like something powerful has just missed you by inches, and it grabs attention instantly without needing any buildup or explanation.