The former Performance Center trainer also reveals Cole was emotional before and after his final NXT match