Put it at the end of a confident build-up, right after the character's threat fails, then follow it with the Womp Womp Fail Sound to underline the defeat and the Awkward Moment Sound Effect to stretch the moment before the next scene.