"We've concluded that management in our company can't create value for shareholders by going into wind and solar," Chevron CEO Mike Wirth told CNBC.