True Torah leadership, that which parashat Pinchas extols, serves the people by standing before G-d and seeking His council in leading the nation.
Although sometimes the Jewish People's welfare requires the acts of a zealot, and G-d justifies it retroactively, that is the exception to the rule.