A high-profile opponent of the ban on large high-sugar drinks in New York City has admitted defeat in attempts to block the measure.