Nobel–winning economist Robert Shiller told CNBC on Wednesday "I'm nervous" about Donald Trump, but said there's no doubt the president-elect's personality has ignited widespread excitement about future prosperity.