President Obama said Tuesday that U.S. intelligence has had considerable success, but that the botched Christmas Day attack shows "the system has failed" in a major way.