When President Kennedy called for putting a man on the moon by the end of the 1960's, everyone thought he was inspirational giving the country a positive goal we all could join in on to strengthen the country and remind us we're all Americans. Why should anyone be opposed to Trump's similar recommendations other than you just don't like him?
Nothing wrong with setting a goal to establish moon bases and go to Mars. The thing is people have been talking about this, and working on this quite successfully, for years, so I'm not sure Trump deserves all the credit. It is like if Kennedy gave the moon speech, and we had already developed the rockets, and had sent the capsule up to the space station and it worked fine. In that case, instead of calling Kennedy an inspirational genius, people would probably ask where he has been all this time. Or kind of like setting a goal to develop and deploy the iPhone 12.