Every group of people was self sufficient (or dead) at some point. We just want to keep improving our quality of life at rate that demands more division of labor. Scale that back a bit, of course colonists with have a lower quality of life, they are colonists.
Then scale back from 100% self supporting and make a place on mars that is most self-supporting or self-supporting in an emergency. They don't need to be self sufficient from day 1, they need need to be self sufficient enough to eventually get by without constant injection of resources. At some point that can be part of this economy that makes it unprofitable to have self-sufficiency on Earth, but because of trade costs the economics will look different, but not impossible. Locally source will be 1% the cost so buying from Earth with done only for the most valuable items. Things like seeds or IP make perfect sense to buy across the gulf of space. Thing like bulk lumber and toilet paper do not and probably never will.