Kempsey man charged over attempted robbery at Macksville licensed venue