City council queries timing of overnight alert after ‘exceptionally heavy rainfall’