True. BUT, we have people on here saying they are useful over tens of yards - on horseback! And against infantry! What they forget that if infantry are attacked by cavalry, they fire at the horses - a bigger target and certainly upsets the rider when the horse goes down. (King Henry V's archers at Agincourt (1415) didn't kill many knights in heavy armor, they unhorsed them - and the foot soldiers finished them off!)
Handguns are pretty useless beyond a few yards and not much use in battle.
The Brits during the Crimea War (1854-55) and the Indian Mutiny (1857) preferred the .44" 5-shot double action British pistols to Colt's .36" 6-shot single action revolvers because they could get all 5 shots off before 2 on the Colt, and the heavier round disabled the opponent far more reliably. It stopped the opposition before they got to bayonet/sword-length. Again, there are many who trumpet about how much more accurate the single action Colts (et al) were yet, as you say, they were not used over particularly long distances. Yes, a double action is a much heavier and longer trigger pull which upsets aiming, but if you are just 'pointing'' ....
"I had one of your largest sized Revolver Pistols at the bloody battle of Inkermann, and by some chance got surrounded by the Russians. I then found the advantages of your pistol over that of Colonel Colt's, for had I to cock before each shot I should have lost my life. I should not have had time to cock, as they were too close to me, being only a few yards from me; so close that I was bayoneted through the thigh immediately after shooting the fourth man." (from a letter to Adams from: J.G. Crosse, 88th Foot (Connaught Rangers)
Lt. Col. George Vincent Fosbery: "An officer, who especially prided himself in his pistol shooting, was attacked by a stalwart mutineer armed with a heavy sword. The officer, unfortunately for himself, carried a Colt's Navy pistol of small caliber and fired a sharp-pointed bullet of sixty to the pound and a heavy charge of powder, its range being 600 yards, as I have frequently proved. This he proceeded to empty into the sepoy as soon as he advanced, but having done so, he waited just one second too long to see the effect of his shooting and was cloven to the teeth by his antagonist, who then dropped down and died beside him. My informant told me that five out of the six bullets had struck the sepoy close together in the chest, and all had passed through him and out of his back."