I recall having that exact experience as a kid. It was equally disappointing (it definitely ruined the rocket), and hilarious. Finding the remains of the rocket protruding from the earth, like a sad javelin sent from the heavens, still lightly smoking... priceless. Thanks for unlocking that memory, those were some great times.