Twitter's head of trust and safety under Elon Musk has resigned amid backlash over the social media site's moderation of an anti-trans film.