Billionaire investor Mike Novogratz said in an interview with CNBC that most of the crypto carnage is done.