What does this mean?

To earn the medal (and the SPs that go with it), you have to destroy, whether by attacking or defending, 250 naval "main attack units". In the default world map, naval main attack units are destroyers. But on custom maps, naval main attack units can be any units the map creator decided they would be.