A major exchange-traded fund manager suggests the oil trade won’t provide much upside ahead.