A scathing report has found emergency services failed during the deadly Northern Rivers floods earlier this year.