Demand for oil will not shrink overnight despite governments preparing for a transition into electric cars, the CEO of Shell told CNBC on Thursday.