From what I can remember, it just requires someone to be in a comatose state to control it. I don't think it was permanent. However, in one of the epilogues, it said that Equestria would take a while before it could trust the Pegasus to control the weather again. Either way, they can still talk with Pip. Otherwise it would have been way to sad. I really love her as a character.