A CNN survey found he has the worst early approval rating of any US President in history