I don't think the Battle really compares with the 'Tarpon' for a number of reasons. The Battle was lighter - because it didn't carry any naval gear (like folding wings, arrestor hook, extra navigation kit etc.) was not strengthened for carrier landings, and also didn't have self sealing fuel tanks (as far as I know) didn't have armor, and was far less well armed - it also certainly couldn't carry an internal torpedo! So I don't think it's a realistic comparison. The 'Battle', a much earlier design, was not really ready for "BATTLE", let alone carrier operations. The differences in the combat histories are also pretty stark.
I don't think that is actually true. The Avenger / Tarpon was in action at Midway and pretty heavily engaged from Nov 1942. At that time US fighter protection was pretty marginal both because of limited numbers and relative effectiveness compared to Japanese fighters. Fighter cover tends to sometimes be looked at as a binary thing, either they have it, and you are good, or they don't and your bombers have to fend for themselves. The reality is that it's quite a wide range, and fighter escort does not automatically equal air superiority / supremacy. Until large numbers of F6F and other modern fighters were available in the Pacific in 1944, strike aircraft active there were decidedly not in a permissive environment.
The F4F Wildcat was hard pressed to survive an engagement with A6M or Ki-43 fighters, and often provided little protection for US strike aircraft from 1942 through the end of 1943. This was particularly true in carrier engagements. So any strike aircraft needed to have characteristics - defensive armament, maneuverability, armor, and good handling, that enabled them to survive attack by fighters and evade destruction. The SBD was quite good at this (despite not looking so good on paper or from a 'rivet counting' perspective). The Devastator, Swordfish and Albacore did not seem to be. The Avenger / Tarpon was somewhere in the middle. They took losses but being intercepted wasn't necessarily a death sentence. They were strongly built, armored, had self sealing tanks, and had fairly heavy defensive armament including a power turret with a 12.7mm defensive gun, plus a 7.62 mm in the ventral position. A Fleet Air Arm Tarpon once shot down a Ki-44 in an aerial duel over Sumatra. I don't think you'd want to fight that engagement in a Swordfish, a Devastator, or a Battle.
Well, I hope you aren't referring to me as a 'rivet counter'. I am personally far more focused on context, as in the historical records of combat, than on statistics, but I think in naval combat a 100 miles or more of a range advantage is not insignificant, it's one of those hard realities. Things like top speed, dive speed, rate of climb and cruise speed, armament, armor, and so on are more incremental, but they do add up. Ultimately though, the proof is in the pudding. And by that I mean, what actually happened when they were put to hard use in action against the enemy.
I was comparing the Avenger-Tarpon to the Albacore in my post showing relative performance, not the Swordfish / Devastator. The two debates have become somewhat overlapped.
The Devastator was just a bad design. Many other designs of that same early era were far more advanced and effective. Some like the Spitfire and the Bf 109 remained in use through the end of the war because they were so effective. Others like the designs which became the D3A and SBD, proved highly lethal and versatile in combat through at least the mid-war.
The Swordfish may have been the result of the severe limitations of the ships they were meant to fly from, I find less credibility in that explanation for the Albacore. The Avenger was a huge, ungainly, lumbering gas-guzzling beast of an aircraft, certainly not an elegant or beautiful design, but it turned out to be the best torpedo bomber in the Allied service for the period of the war when the fighting was heaviest. It was the one both the Americans and British relied on.
What they did with the Swordfish, such as effectively fitting radar to it, is pretty amazing, and I think it does tip the scales in advantage of the Swordfish over the Devastator. But given the choice for operations in the Pacific, you'd be better off with Avengers/ Tarpons, which is why that is what they actually used.