I wondered about this so checked what happened to Joseph McCarthy. He was subject to a vote of censure in the senate, and became unpopular, but that was it. Of course he died shortly after of alcohol related conditions, so there's that..