The CEO of the website called Twitter by most people is leaving her role after a tumultuous tenure that saw the social media platform's popularity plummet under billionaire Elon Musk's ownership.