Melvin Capital closed out its short position in GameStop on Tuesday afternoon after taking a huge loss, the hedge fund's manager told CNBC.