Why isn't my sea texture appearing transparent/translucent?
It's likely just the blend mode that needs to be changed on the material tab.

On Opaque, it's telling the renderer that this is a solid object, but when changing the visual properties to something like Additive, you should be able to get the expected results.