Well considering that the objective is a really big bomb, it's hard to think of how else they could end.I don't like how theirs only two or three ways for Payload maps to end. It's only 'Dont Explode', 'Explode', or 'Explode in Water'.
Also there's no better ending to a map (or anything, really) than with a massive explosion that demolishes everything in the area.