Well, McCarthy ended up being censured by his own Senate colleagues, so he obviously wasn't very popular toward the end of his mercifully brief tenure in the public eye.
You'd likely have to stop his crusade from going off the rails, and I don't know exactly when that happened. Maybe when he went after the army?