Several people in the Bahamas witnessed the explosive wreckage of the failed Starship rocket as it flew across the sky