Friedrich Merz called a local election defeat for his Christian Democratic Union party a “disaster”.