Put it just after the failed moment in your edit, then follow it with the Womp Womp Fail Sound to underline the defeat, and close with the Awkward Moment Sound Effect to end the scene.