Not much consolation, but here is how it works for transmission pumps and every other part on our trucks.
Say, for the sake of argument, that 99.9% of those pumps do not fail in the first year.
Ford sells more than 500,000 F-150's in a model year. If just 1/10th of 1% of that 500,000 fail, that is 500 trucks, 10 per state on average.
Until Ford starts making 100% perfect trucks, it is always going to be someone's turn in the barrel.
(look it up).
Unfortunately, it seems like it is your turn. Next time it may be mine, it has been before.
Many years ago I bought a brand new Plymouth. After a month or so, I noticed oil puddling under it, so back to the dealer. In those days you could still wander into the service area. They had it on a lift, engine running, and 2 guys are looking at the side of the block with a light. As soon as the first guy would wipe it off, you could still see oil appear in a flat, open area.
Porous block, new short block, loaner, such is life.