I don't think NO will ever come back. There might be a French Quarter and some hotels, but I think its days as a major city are finished.
There will be some infrastructure for energy insdustry too, but I agree. The city is radically changed - as in virtually gone.