The actor has reflected on how one of his roles changed his marriage forever