Put it at the very end of the clip, after the petty moment has played out, then follow it with an awkward moment sound to let the embarrassment sink in before cutting to a disappointed reaction sound for the final beat.