Security camera footage captured the moment a historic Connecticut church's steeple and roof collapsed on Thursday, leaving a gaping hole in the top of the building.