Funeral For A Friend - Tales Don't Tell Themselves.
A concept album about a fisherman caught in a storm and becoming adrift before eventually shipwrecked on an island. Meanwhile his wife and child in his fishing village fear him lost to the sea and come to terms with it. Specifically All Hands On Deck Part 1 and 2.

For the more metalcore, 36 Crazyfists mentioned water and waves across a lot of their songs. They have albums called The Tide And It's Takers or Collisions And Castaways, or even the song Elysium from Rest Inside The Flames was one of the first I thought of that even mentions an ocean.

In a pop-punk sense, Alkaline Trio have the underrated Wash Away from a Tony Hawk's soundtrack, more about rain than large bodies of water.