The popular Black comedian, a native of Winston-Salem, North Carolina revealed in his latest HBO special, called “Rothanial,” that he is gay