Well, i can’t sink a destroyer with my deck gun actually!
I even can’t stay in their vicinity or I’m dead (i have increased their gun accuracy)
Now easy way for you to get this sinking effect, is to take NYGM ships flooding values in Zones Cfg file
... and even increase ships hit points...