Republicans wouldn’t have a hard time "demoniz[ing]" him. He’s a shady, unlikable insider/career politician and partisan hack who only won his races (including 2021) because he was running in an inflexible blue state. He’d lose to any halfway competent Republican opponent in a national race.
Yes, he has all of the same problems as Hillary Clinton with none of the history-making potential to drive up Dem turnout. McAuliffe would be a very bad choice for a presidential nominee and would alienate the median voter in the EC.
He's not a bad fit for VA, though. The median VA voter tends to value career politicians with policy chops. They also aren't fazed by angling for questionable government contracts, because that's probably part of their day job.