Sometimes that single shot can make the difference between fighting a superior foe, enemy, or monster or not fighting at all.
For example Lets say a Giant comes charging at your unit and you have a mounted Captain. The Giant is already wounded and has one wound left, you stand and shoot and manage to kill the Giant. Pistol = worth it.