There definitely were people actively hoping that it wouldn't work.
A couple months ago, there was a post about HCQ where I commented that the evidence I'd seen so far led me to the opinion that if I personally caught Coronavirus, I would be seeking out HCQ.
That post was met with a downvote brigade and multiple comments about how the drug was actively harmful and anyone thinking otherwise was an idiot.
I agree that we should let doctors do the studies and figure things out, but especially at the height of the media / political press against HCQ, even the idea that someone might personally be willing to bet on the drug's efficacy was met with a lot of disdain.