Place it right after the failed moment in your edit, not before the reveal, so the reaction answers the mistake. Follow it with Sad Violin for the aftermath, or lead into it with Sudden Suspense when you want the failure to feel bigger first.