While it’s very clear that no one anticipated the brouhaha, it’s not clear that it has staying power. Some, er, leaders continue to pour gasoline on the fire, while others would rather pour oil on troubled waters. The New York street is divided, though national public opinion is firmly (though I believe temporarily) against the deal.
Indeed, Robert Kaplan, second to none in his support for U.S. security, has very high regard for Dubai.
Update: This longish NYT article about port security indictates that things are better than I expected, but still worse than they need to be.