NASA will continue working with the private sector to fund space exploration efforts under President Trump, a former deputy administrator told CNBC.