Families have agreed to call off the search for nine people still missing after a US nuclear submarine collided with a Japanese fishing vessel.