The cargo ship became stuck just off the coast of Brough on Sunday