With commodity prices rallying off historical lows over the past year, pricing in "robust" expectations, but now, markets need to see real demand, Goldman Sachs said.