Place it at the end of a fail sequence, after a gun shot sets up the explosion and before a reaction sound closes the moment. Pair it with a boom headshot for a second impact, or follow it with awkward crickets when the joke needs a dead pause after the disaster.