Widespread flooding on Canvey Island was caused by "sheer volume of rainfall" rather than a failure of the drainage pumps, a report has concluded.