I had not seen that in years. I had absolutely forgotten how off the sound effects were. That's not the proper sound at all. I have seen melon's explode, not using explosives, and there is no gunshot sound (unless, naturally, a gun was used). It's more of a splorch or, really, what you'd expect when a medium-brittle container holding what is essentially jello, is suddenly broken open. Yes, I have accidentally dropped the occasional melon, and had it burst open.
The Foley Artist really missed an opportunity. I think he should have gone with a
Wilhelm scream here.