In the footage, a powerful blast erupts from the base of the rocket, engulfing the surrounding area in flames and smoke