I agree with you! Capabilities should be weighed across the whole of the game, not just combat. It needs social and exploration tiers to balance the characters appropriately. If the fighter could be best in combat and the bard is balanced to not be combat-focused, that's fine with me - to some that might mean that their bard is "useless", but in my opinion the bard should excel in the social situations and mostly sit back in combat. That would mean that enemies would likely have to have less HP so that the combat would end in a somewhat-reasonable time if only a couple characters were truly engaged in the fight, and then we're getting in the realm of either another edition, another game, or significant houserules...
But unfortunately, combat is the only tool in the toolbox that WotC seems to want to balance characters against, and the characters that would be more flavorful in other situations (ranger) are just meh. Why hunt/gather for resources when Conjure Food and Water exists? Or create shelter in the wild when there's Tiny Hut?