Two comedians say the stage has become a vital space for visibility as Pride Month comes to a close