I’m intrigued whether most Germans woke up one day, perhaps after the death camps were reported on, and that’s when the nation changed and abandoned Nazism and anti-semitism. So, did many citizens all the sudden realise it was all a terrible lie? Or was it a gradual decline in the minds of the population that took many years? I understand every individual is different, I’m looking for a general overview.
I think this is an impossible question to answer. They didn't have Gallup polling in Nazi Germany, or social media you could do a meta study of, so the only way we could kind of infer popular support or the lack thereof is by looking at the results of a popular revolution or an election during the war. Neither of those things happened. Without those, you'd be relying on accounts from individuals and their personal estimations of public sentiment, which would be limited to those they came into contact with, and subject to their personal biases.
There are enormous problems answering a question like this. Take for example the fall of the USSR. It is amazing to read today the number of formerly staunch communists who claimed they "knew all along" what a mistake the Soviet Union had been. Revisionism is a huge issue when it comes to defeated political ideologies. The old "yeah my grandpa was in Germany in WW2, but he was with the resistance from the beginning" comes to mind.
In addition, the fact that both post war Germanies were occupied by nations extremely unsympathetic to the Nazi ideology would have made it virtually impossible to get an honest opinion out of anyone. You could possibly look for clues in the figures of the number of pro-Nazi demonstrations, instances of sabotage, instances of crimes against Jews, collections of Nazi paraphernalia, etc. But those really just describe a continued willingness to fight on behalf of the ideology. Even after that sort of thing died down, loyalty to the old regime and its ideals could have existed silently in the minds of many, and you would never know.