That was the point of the Galaxy-class of course. It was meant to be less “rough and tumble sailors” and more “long term cohesive floating city that could technically be self-sufficient for 10-20 years and show the technical prowess of the Federation” . Had to be big to support the 1000 crew compliment.