What hurts public trust in climate science is primarily a massive and well funded propaganda campaign that's been going on for 50 years.
Some scientists are going to sometimes be wrong about things. It is impossible for them to be scientists otherwise.