Coon Island name 'about as offensive as you can get', says Stephen Hagan after motion to consult Lake Macquarie community about renaming