The max range on 12 lb gun was 1440 yds. At that range, they almost always hit the earth. Somewhere.
Artillery has been, for MOST of history, an area type weapon, as opposed to point type. The Napoleon was a smoothbore, and standard loads were shot- a solid metal ball, Shell- a hollow projectile with a bursting charge (and lead balls inside) and canister- a bunch of smaller lead balls, packed in a thin metal can. On firing, can ripped open, giving you God's own shotgun. Max range with canister 400 yds.
Shot might be used for counter-battery fire, or damaging structures, but the challenge would be estimating range- trajectory like a rainbow. Accuracy was about 1 degree laterally- about 60 MOA.
For anti-personnel work, you did not aim at a soldier- you aimed at the MASS of advancing Infantry or Cavalry. Target was not Fred- it was Fred's Platoon. With shot, you attempted to strike just in front of the group- and bowl deep into the lines of advancing troops. Shell- you cut fuse to try to detonate just in front of, and before it hit the ground. (what you see in the movies are ground emplaced charges SIMULATING artillery fire)
What we have here is... failure- to communicate.