A frantic search for three NSW fishermen missing off South Australia’s coast has ended in tragedy.