The bubble in private market start-up valuations will end badly, Kevin Kinsella of Avalon Ventures tells CNBC.