they wanted to have both a well-established space-faring society but also an american frontier settler-brainworm aesthetic

I'm glad I'm not the only one that picked up on that. In that "making of" video, Bethesda made a huge deal about wanting to capture "the wonder of space flight and exploration", but at the same time having space travel be routine. It'd be like getting excited by driving down the highway.