Torrential rain causes dangerous flooding across South; Roof of historic Connecticut church collapses