The pistol from the original Halo was bad. It is obviously too powerful for a starting weapon. It reduced Halo multiplayer to a four weapon contest: the sniper rifle for extreme distance, the shotgun and Rocket Launcher for very close fights, and the pistol for everything else.
They will never make another pistol, or anything of its power level. And that's a good thing.