Yes, he should resign. He not only dissed his wife and children but he also betrayed the trust of every one of his constituents.
I’m guessing he isn’t up for “Father of the Year”