Colchester United defeat will haunt League Two boss 'for rest of his life'