Only against weakly defended targets, rockets deliver less and dispersed HE, and launched at a shorter range than a dive bomb attack to boot, try that against tougher opposition and they are toast.
IIRC, rockets used for anti-shipping strikes were fired to strike the water , where they then proceeded UW to strike the ship's hulls below the water line. I know this is how they were used against submarines, and rockets could penetrate a sub's thick pressure hull in this manner.