I'm not sure that Sanford will be much of an 'embarrassment' regardless of how hard the media tries. Regardless of what I think about his behavior, the simple truth is about half of marriages crash and burn.
If this doesn't become a habit with Sanford, I suspect it will be forgotten about by everyone save for his detractors.