Artemis is the best missile/torpedo even into the late game?

So i was just looking at all the numbers on the missiles Ive unlocked for the mid game, and it seems my initial thinking is a bit flawed, i recall from a perun video and then another detailed explanation that the consensus was the only metric which is important in a guided munition is the delta v.

looking at these numbers though i think that is flawed. assuming both fleets are closing at 650m/s then a 4.9g missile will impact with a final velocity 9.9km/s of which only 8.6km/s is dV from the missile so any dV beyond that is simply wasted (unless of course it flies on past to a target behind).

Compared to a missile with 9.1g acceleration it will (with unlimited dV) impact with a velocity of 13.4km/s if you have less than that it means you reach maximum velocity sooner.

so compare an Athena with an Artemis as the Athena seems to be claimed a direct upgrade. The Artemis reaches its maximum closing velocity of 9.3km/s about 520m away from the enemy. the Athena at the same distance is only travelling about 6915m/s. this means the Athena has a greater exposure to PD which is typically significant from 500km anyway. I just cant see the 20% extra warhead and 30% greater fleet strength value of the Athena compensating for it. the only advantage I see is the Athena has deltaV to terminal guidance but i cant see that having much impact. none of this would be an issue if there wasnt an arbitrary cap of 1000km on targeting range

This seems to be a problem with every missile after the Artemis, they just don’t match the acceleration and deltaV. Am i missing something here, i genuinely cant see a reason to upgrade from Artemis (i dont want nukes as i want the salvage)