US households with a red line face increased risk of flooding due to climate change