Oversupply may have sent oil prices down, but in five years there won't be enough to meet demand, John Hofmeister says.