Put it at the exact moment of destruction, after a short fail cue and before the reaction shot, so the edit moves from setup to payoff to response. Follow it with Vine Boom Sound Effect for a bigger impact, or lead in with SpongeBob Fail Sound Effect when the mistake is the joke.
About this sound
This is the brief game blast from Minecraft that players link to TNT and creepers wrecking a build. It lands hard and playful, turning a small mistake into instant chaos that feels funny rather than serious. The sound comes from Mojang's sandbox game, where explosions are a normal part of play, so even people who never play recognise it at once.