Place it immediately after the failed attempt, before any reaction shot, then follow with the Womp Womp Fail Sound to deepen the joke or the SpongeBob Disappointed Sound when the miss is more awkward than unlucky.
About this sound
This is a brief, soft group 'aww' lasting under two seconds, the kind of collective sigh that follows a missed shot or a weak result. It feels gently deflating and a little funny, adding mild embarrassment without turning the moment harsh or dramatic. The reaction comes from Wii Sports on the Nintendo Wii, where it became familiar through repeated matches and party play.