Pinchas was immensely rewarded for his act. But he didn't take over as leader after Moshe Rabbeinu. That was Yehoshua. Perhaps that could be because when someone does such a cruel act he's viewed differently. He can't be seen as cruel and be a leader at the same time..