A CNBC report finds increasing U.S. acceptance of nuclear energy, with support climbing steadily as new reactors gain momentum—while enthusiasm for renewables shows signs of decline.