The commander of US and Nato forces in Afghanistan took his apology for an airstrike that killed civilians directly to the Afghan people, with a video in which he pledged to work to regain their trust.