I would bet that we reach a level of commercial space travel akin to commercial air travel. The moon/mars will have some form of rudimentary base, probably after a couple of failed attempts. Though I don’t think they will be colonized in any real way.