I get your skepticism, but does it not help that pharmaceutical studies are closely reviewed by the FDA before a drug can be marketed? Getting a new drug approved is far from easy.
Even after using all the known tricks for cherry-picking results, p-hacking, and the like, there exist much-abused FDA 'fast track' options for getting a 'needed' drug out before the science is confirmed, and quite often the science never gets around to being confirmed. Even big-name drugs like Tamiflu have been shown later to be no better than generics at best and completely useless at worst.