As far as I understand the relays, the only ways it could fail are stuck on or stuck off. If it were stuck on, the TCM and trans would always be getting power, so the light would be on even when the truck is off. If it were stuck off, there wouldn't be any power going to most of the trans parts...