Place it right after the mistake is shown, as the reaction that closes the scene, then follow it with the Awkward Moment sound to stretch the moment and the SpongeBob Disappointed sound to underline the letdown.