Good points - early firearms were basically only effective at short range and when using massed firepower. A primary value of them was the shock & awe of the loud noise and smoke scaring horses.
...
This is different from the value of bows and crossbows... how? Well, other that the fact that early firearms could actually hurt someone, whereas bows and crossbows had been completely sidelined by mass armor introduction. Loud noises and smoke scaring horses might, just conceivably have been of some value up to, say, 5 years after significant adoption of firearms, but we know that you could train horses to deal with it, so it completely fails as a major component of the utility.
Bows *suck* as weapons in RL. Bows *are not* long range weapons. Bows *are not* armor piercing weapons. There is a reason that the only people who used bows were people who could actively avoid melee (siege, navy, horse archers), *and even those people at best used bows as coequal military arms*.
Which does, I suppose, bring us slightly back on topic: part of the reason guns do poorly in DnD is that DnD overstates the performance of bows.