...yet.
But I would argue that manned exploration and colonization of other worlds is our eventual path if we want to continue to advance ourselves as a species. Because of that, I believe it is the most worthwhile thing we as a people can put our time and resources into.
The moon and mars will just be practice areas and jumping off points for the real adventure ahead. Probably not in our lifetimes... but maybe our children's... maybe...
I agree, however continuing to go to the moon is a waste of resources that can be better spent developing the technologies that will allow for colonization off planet. At this point we don't have the technology to get us to a colonizable planet nor do we even know where one is. None of this will happen until we create a gravity device capable of folding space-time. As for building "generation ships", this is stuff much more readily done in Earth orbit rather sending the materials to the moon. The ISS program is still running and it is the development and proving ground for the technologies and methods required for that approach, as useless as I see it being.