Actually, I think the tweet is totally fine. Being a mother, partner and daughter is all totally possible and gender appropriate to females.
"Going back to be fathers, partners and sons" would be no less appropriately worded.
This is not demeaning or disparaging at all. It's well written and phrased in fact. The post venerates the athletes as heroes too. Although calling them heroes is suspect, superficially speaking and perhaps philosophically.