This is the uncommon 'OLD PROFESSIONS' joke that works because it's not trying to be a pun on death. Rather, 'reign forever' implies professional immortality as well as being a pun on 'rain', a type of precipitation that weathermen predict.
OLD WEATHERMEN never die , they reign forever .