Hurricane Helene, which has weakened to a tropical storm, has destroyed homes and brought life-threatening flooding to wide sections of the United States's south-east.