I just think people have misunderstood his role. Fauci is not a politician at all, he's a Doctor. His job here is to diagnose a public health problem, and prescribe a solution. He doesn't force that decision on Trump, or claim it's the only perspective that exists, he just advises based on the best available scientific data. He does not advise on economic matters, because that's not his expertise, and there is somebody else to do that.
He's been popular throughout this process because he is a direct line to scientific facts, in a sea of political nonsense. But that is also the reason why some Trump supporters and conspiracy theorists turned on him so early in the process. It all started when he pumped the breaks on Trump's praising of Hydroxychloroquine. People are so accustomed to being partisan that they actually perceived this as a political move on Fauci's end, which is so incredibly moronic that it's almost disheartening to see. It has absolutely nothing to do with politics. Fauci would never tout a drug designed to treat a different illness just based on word of mouth that had not gone through clinical trials, because that's so specifically antithetical to what he does for a living. When you're the Director of NIAID, you can't be a guy who just wings it.