…Does it go into the discard pile, or does it stay in front of the revealed player or something as a stigma for the rest of the game?

A: It goes into the discard pile, and, yes, that means that if the discard pile is reshuffled into a new draw pile, someone may draw it again in the same game.