He has no honor, obviously. But yes, he should resign. Or be impeached. Or removed via the 25th Amendment.
If we're going to retain even the tiniest shred of dignity and decency in the office of the President, if we're going to retain even the slightest remnant of credibility and respect on the world stage, he must go. As soon as possible.
And even if he were to do that, I'd suspect that the chance that Vance bringing us back to any degree would be 50/50 at best, given his white "christian" nationalist tendencies and proclivity for insulting world leaders who are vastly more experienced and qualified than he.