> It’s because ultimately the species survives, not the individuals.

No, this is wrong. "Survival of the species" isn't a basis for selection. It will not lead to a gene becoming more prevalent in a population of interbreeding individuals.

Bees sacrifice themselves because they share genes with the queen; genes that are involved in this sacrifice increase their relative abundance in the bee gene pool by increasing the fitness of the superorganism that is the colony.