Place it right before the failed play in your edit, then follow the mistake with Sad Trombone for the payoff. If the moment starts with hope, open with Crowd Cheering first so the warning cuts the excitement before the fall.