Place it immediately after the failed moment in your edit, letting the reaction carry the scene before you cut to the next clip. Pair it first with the Womp Womp Fail sound to underline the defeat, then follow with the Awkward Moment sound if the scene needs a slower, quieter ending.