Place it at the turning point, just after the mistake becomes clear and before the fallout unfolds. Pair it first with It Was At This Moment He Knew to frame the realisation, then follow it with a fail sound once the outcome lands.