Thing is we saw in Nicaragua(?) how useless supes can be in actual combat.
Quite effective really; Payback were revealed to be working with the Spetsnaz team to subdue Soldier Boy (while killing or scattering all the CIA and Contra allies in a deniable way).
Vought was willing to paw off their then premier 'supe and sour relations with the US security/military sector to wheel out Homelander.
Having Soldier Boy storm the beaches at Normandy would have been a huge distraction from the winder battle, especially given he doesn't seem big on the whole taking orders thang. He'd likely run off on his own side mission leaving the men he was supposed to be leading vulnerable.
I think he was effective like Black Noir, but still be deemed by US Army brass as a "shit show" by being too efficient and brutal against both Nazi troops and innocent locals alike.