The singer-songwriter had a string of big hits including 1976’s “The Wreck of the Edmund Fitzgerald,” based on a true story of a doomed freighter