The UK failed to secure the Brexit agreement it wanted for Northern Ireland, its negotiator has admitted – despite Boris Johnson hailing it as “a great deal” at the time.