The 41-year-old singer apologised to fans in Auckland, New Zealand for the cancellation