Not really. The rod would just go right through, and the body woudl damage maybe one compartment? There's a reason ship killing missiles tend to have big warheads. There's a lot of ship, and it tends to be blast hardened.I wonder how effective the CKEM would be against a ship. Could probably get a mission kill.
Was more thinking if it hit the mast or bridge.