In practice ships at sea of all sizes didn't do any better. The ammunition expenditure v the relatively few number of hits obtained throughout WW2 by all navies is staggering. Some data here.
It was something that was commented on by the Admiralty at various times all the way through to the final actions in the IO in the summer of 1945.
Thanks. As an aside, that partially explains why navies were so eager to replace guns with guided missiles as soon as those were even rudimentarily functional post WWII.
Same goes for SAMs vs gun based heavy AA.
