Direct hit! Spectacular moment decommissioned US Navy frigate lifts out of the water and explodes after being TORPEDOED during combat training exercise