Thanks for the good answer and don't worry too much about a small off-topic excursion ... as long as we get back to before too long, but I disagree a bit again. Not with what you stated ... it is ALL true with the exception of the part where the pilots planned the number of hits and the effects ... at least that is what I think.
In reality, they flew the mission and if they saw a ship or other target of opportunity, they might strafe it with the 75 ... maybe. If anti-aircraft fire was absent (merchant ship), they might make multiple passes. If it was a warship and they were stupid enough to strafe it the first time, they would NOT be stupid enough to strafe it twice or more times unless THAT SHIP was the primary target. I cannot think of an instance where strafing a warship was the primary mission for a big-bore cannon aircraft. I might have missed a few, though. We mostly attacked warships with bombs and torpedoes, not with airborne big-bore cannons unless it was a "target of opportunity."
Now if the A-38 had been put into service maybe that might have changed a bit, but I don't think a 75 against an armored warship would be a big threat while the ship would be an enormous threat to the attacking A-38. This was a BIG airplane and, as far as I know, it carried only 20 rounds for the big cannon. But you have to admit, it was a LOT faster and more mobile than the horse-drawn or truck-towed variety of 75.
Since they only made two A-38's, we don't know where they might have been deployed. I rather think it would have been a tank / train buster in the ETO and perhaps maybe a support plane for island invasions in the Pacific. I'm thinking pillboxes and maybe Japanese light tanks. Might have a mission against ships in the MTO or North Africa ... but would probably be mostly against whatever ground targets were moving around or were obstacles. In the desert you can just walk around the obstacle and leave it behind in the sand, so maybe ships were a more likely target in the MTO.
I fully realize the necessity of artillery effect tables for ground warfare, but cannon-armed aircraft didn't usually have anything to do with that concept during WWII. The bombers? Yes. It came into play a LOT for sizing the attack. As long as you HAVE the aircraft, why send more than necessary to hit a target? If you needed more than you had, it resulted in a maximum effort mission. A post-attack BDA would prove the table or not if done in good weather. But throw in smoke, fog, clouds, or any serious weather and the BDA could easily be changed by 60+% just due to weather effects on bomb aiming and by obscuration of the target by clouds.
Not so with Army artillery. Regardless of the weather, stationary targets didn't move around and effects could be predicted with decent reliability. If you can get the Army guys your coordinates, they can place fire VERY close with very good accuracy. Not necessarily so with aircraft. A LOT has to do with the winds aloft, the g-force and angle of attack, and the inherent accuracy of the bombsight, plus any number of other minor factors ... none of which would be present for ground-based artillery attacks.
I LOVE airplanes, but if I needed close fire, I would rather call in an Army artillery attack than depend on a fast-moving plane. Of course, in places like Viet Nam, you might not be in range of artillery and so HAD to depend on the planes. Mostly they delivered well. Sometimes not. Again, weather and the surrounding terrain were big factors along with the karst. We had Skyraiders shooting within 20 meters of us sometimes, but that was only when WE called it in, and their cannons were of the 20 mm variety. What the hell, if you are about to die, then calling in some airborne cannon fire VERY close isn't a bad option.
So I agree with you whole heartedly for ground-based artillery, but am not so sure for airborne big cannons. I think they tried for a hit or hits and hoped for the best given the cannons they were issued with the plane. I have only spoken with two guys affiliated with the big-cannon B-25's and both said the big-guns were devastating to the targets but were never the primary weapon until the bombs ran out ... the big gun-equipped B-25's could still carry a bomb load.
Now the German Henschell HS 129B-3 sometimes had a 75 mm cannon with 12 rounds in the magazine. It was the 7.5 cm Pak 40 anti-tank gun, a lighter-weight, fully automatic aircraft-mountable version, with a completely different and more aerodynamic muzzle brake to produce the Bordkanone BK 7,5 model. It was primarily used as a tank buster on the Russian front. It is supposed to have been a pretty decent attack plane against tanks. I suppose that some 4 to 12 of them flying around a battlefield would have caused a lot of consternation to Soviet tank crews. It sure would have made ME nervous.
Even today, I bet an old Sukhoi Su-25 Frogfoot or two would cause a big pucker factor to a tank crew.