Elon Musk says the SpaceX rocket that blew up is proving to be the most complex failure the firm has faced in 14 years.