The ongoing scandals involving President Donald Trump could put an end to his presidency at a time when his approval ratings are at an all-time low, a political analyst told CNBC on Monday.