Place it right after the gross reveal, then follow with the Womp Womp Fail Sound to underline the failure, and save the Awkward Moment Sound Effect for the moment that follows when nobody knows what to say next.