No, he clearly said that a "second home for humanity" is of dubious (but potentially nonzero) value.
Rather, the main benefit would lie in the technological advances made in order to enable such a Mars mission in the first place (similar to advances during Apollo).