It is important to note that people have a wide range of attachment to their gender identity, ranging from willing to undergo extreme body modification in order to match their gender identity, to those who don’t care in the slightest.
The issue is that cisgender is the default, and if you don’t have a strong attachment to your gender identity, you have no reason to change the label. Hence, cisgendered people have a wide range of attachment to their gender identity, from strongly identifying with it to no attachment at all.
(There is also the group of agender, which includes those who have deeply examined their gender identity and decided that they don’t really care (and probably also want to signal their examination and non-caring of gender identity))
Someone who is transgender obviously has an attachment to their gender identity, and this is obviously from which the Pronoun Discourse stems. They have a strong preference for a gender, and a preference to be referred to with the appropriate pronouns, and thus being misgendered is upsetting, as their preferences are violated.
(Of course, most of this rests on the ability to communicate the preference, and accidental violations when the preference was not communicated are less egregious than deliberate violations.)
Otherwise misgendering can be upsetting if it is tied to stereotypes of masculinity and femininity and attempting an insult based off those stereotypes.
Nitpicking at the example, worker bees do not have offspring; the best way for them to spread their genes is to protect the queen and thus, the hive.
Birds can have offspring, so self-preservation instead of risky attacks is optimal for individuals of a flock (of genetically unrelated individuals).
It’s not that the group is less intelligent, rather that the individuals of the group have different goals (self-preservation vs hive preservation, though the end goal of maximizing fitness is the same).
But genetic fitness breaks down as a metric when you add culture to the system, so application to humans is limited.