Well... Al Franken is fine. He was rich and famous before he became a Senator, and he's still rich and famous now. Moreover, his successor was reelected, so the Senate seat hasn't changed parties.
Franken was a liability. Imagine him campaigning for women's rights. It just wouldn't work.
To be clear, though, it was Franken's own Democratic colleagues in the Senate who pressured him to resign. He didn't resign because Twitter told him to.