Cairns Regional Council has apologised to the public after several emergency alerts warning of major flooding were sent in error.