SpaceX's attempt to recover the upper stage of its Starship rocket from the Indian Ocean is now unlikely to succeed, according to company founder and CEO Elon Musk.