It's more than just irrationality. I've never been there, but from what I've seen New Orleans has a unique culture that you can't find anywhere else. It's not irrational to want to be part of that culture, even if there's the occasional risk of flooding.