An over-the-counter drug that initially showed some promise in treating COVID-19, and prompted further study, has shown to be less effective than researchers hoped.