Part of the harm is in people no longer trusting drugs. We're very fortunate to be able to get prescribed a drug and have certainty the risk-reward tradeoffs have been evaluated to extreme depth by experts far more equipped than we are.
I'm not sure how trust would be eroded by the failure of an experimental drug to treat a terminal case where no other drugs are working.