Hobby beekeeper here.

Worker bees dies when they sting a person, because the stinger and venom pump remain when they fly off, ripping their abdomen open.

The purpose of this is that the venom pump continues to function after they have left, making the sting as painful as possible.

Honeybees are a superorganism, where the survival of the colony supersedes the survival of any individual bee.