Tina Smith is leaving at the end of her term, and says she would call Musk a dick even if she had to face re-election