It is like that with how drugs are developed, basically drug companies have libraries of hundreds of thousands of different types of molecules etc that they try and see whether it has an effect on the receptors of interest for a medical condition in tissue samples such as ilium or trachea initially, and then whole animals if its successful, and most of the time there is no effect in the tissue sample or in the actual whole animal it shows unwanted/no effects. Eventually if this is successful, then after a long time human trials can begin and a long time after that it can come to market if after multiple trials it has shown to be relatively safe and of clinical use.
Of course throughout this it could be that the drug actually shows no effect in the condition of interest but it may show 'side effects' that are useful in other conditions.
Why do you think it takes usually about 10 years and about $2,000,000,000 to develop a drug and bring it to market?
The biggest example is probably 'Sildenafil citrate', popularly known as Viagra, which was originally designed as a drug for angina but in humans it was actually shown to have very little effect but the other 'interesting' property was discovered and Pfizer decided to market it for that instead. to recoup their loses and in the process made them a fortune.
I'm studying for a degree in Pharmacology at university and I get to learn about all this sort of stuff all week, its very interesting and certainly gives you a different take on what drugs are and how drug companies work.