Multibillion-dollar unicorn companies will collapse in “spectacular failures,” one venture capitalist told CNBC.