Elon Musk's Mars ambitions continue to be an elusive goal for the billionaire, as SpaceX's Starship test launch in Texas ended with a mid-flight failure.