weathered pipe does come from submarine voyages.

Weatherproof cloth needs seas clear and calm from Sirensong Sea 3 (tier 3 loot)

Weathered Pipe comes from Sirensong Sea 4 (also tier 3 loot)