A closely watched Alzheimer's compound being co-developed by Pfizer failed to show efficacy in one of several Phase III trials.