Why can't we ever have a female president when other states have female governors, female mayors, and female senators?

Partly at least because neither party has yet fielded a good enough female candidate. But you have come close. If Biden had resigned rather than declined to stand for re-election you would have had Harris for a few months.