The CEO will have almost complete control of his Texas-based space company, without colonizing Mars or building a single non-Earth data center.