I feel like a lot of answers here are dancing around why people find it offensive without really addressing it.
As an adjective "female" is completely fine to distinguish between genders when applied to humans. As in "a female athlete" or when a form asks you to select "male" or "female" (ideally with additional options "diverse" and "prefer not to answer").
Where it's problematic is when it's used as a noun. In English "a male" and "a female" is almost exclusively reserved for animals. For humans we have "a man" and "a woman". Calling a person "a female" is often considered offensive because it carries the implication of women being either animals, property or at least so extremely different from the speaker that they don't consider them equal. This impression is reinforced by the fact that the trend of calling women "females" is popular with self-proclaimed "nice guys" who blame women for not wanting to date them when in reality it's their own behavior (for example calling women "females") that drives potential partners away.
So in itself, the word "female" is just as valid as "male" and in some contexts definitely the right word to use but the way it has been used gives it a certain negative connotation.