WEBF - you are of course correct - the Type 42's were clearly vunerable - although I've never seen anyone suggest that there was anything said by anyone at the time they were despatched. And puttung them out as radar pickets was a fairly hairy decision given USN experience in WW2 in the Pacific.
However other ships were out there and weren't destroyed - it's clear there was a problem with the personnel (not just the two fingered in the report) on Sheffield - they never went to action stations, no-one called the cCaptain and the officers on the bridge were "mesmerised" and no action was taken to try and shoot it down.. etc etc
I really don't think it's "an agenda" to recognise that, in this case, there were serious failures by individuals and we really need to learn from these.
There are many other cases in the FI War that show what your average naval personnel (not just exceptional ones) acheived under fire.