The Carolinas braced for a storm that forecasters warned could bring heavy rain — as much as 6 to 8 inches in some spots