I am uniquely qualified to answer. Dr. Shoemaker explained it to me as I sat nervously waiting to take his daughter to a dance. There is nothing there. I come from Flagstaff where the Astronauts trained - Dr. Shoemaker is pre-eminent in meteors and the environment on the moon. Life as we know it is not what we see. We know micro and macro now. We have a grasp of string theory and quantum physics and computers that can run 1 billion options in an hour. We do not need to be any place to get that place. It is now like our minds can imagine and our computations can prove it true or not.
I think it will be fun to have a colony on the moon -- private enterprise of course. Google folks will be walking there within two years. Science will benefit greatly but we can already run that condition here. Neil sat at my dinner table as did others that did not go. There is no governmental reason to be there.
Let me aside --- No way was that the greatest feat of man. Stopping Hitler and ridding the planet of the plagues are far greater feats of man. Space is not the "final" frontier. Man's heart and feeling are the final frontier.