Starfleet ships are typically large because they have to be multipurpose. They have to carry a lot of different tools and a lot of crew for different roles, like agricultural people, scientists who study fauna, astrophysicists, etc. Plus, lots of spare room for projects that may occur during the...