Jimmy Carter had one of the highest approval ratings when he was inaugurated and lost the 1980 election by a landslide. What made the public turn on him?
I know this doesn't directly answer your question, but I wrote a response a long time ago on why Carter is considered a bad president. There isn't a lot in my answer on public opinion, which is what it seems you're looking for, but it does discuss Carter's failures.
As an addition, after his presidency did his approval ratings remain low?
I've only ever heard good things.