David H. Hackworth , a much-decorated and highly unconventional former career Army officer who became a combat legend in Vietnam , then enraged his superiors by lambasting the war on national television , died on Wednesday at a hospital in Tijuana , Mexico .