So will the river dry up?

No… the narrow lake above the dam will be restored to a naturally free-flowing river. The best way to imagine what it will look like upstream of the dam’s current location after removal is by picturing what the Neuse River looks like below the dam today.