Is there more than one switch on the wall? Common practice is to pull a 14/3 wire up to a ceiling fan in case the motor and light need to be switched separately. However a lot of new ceiling fans with remotes only need one switch. It's possible yours was wired with that in mind and the red wire is only capped behind the switch, so it won't do anything at the fan