Sen. Joe Manchin said he offered to leave the Democratic Party if he became an 'embarrassment' but 'no one accepted that'