They are distressed, because they had been confident; they arrive there, only to be disappointed. (NIV)
They were confounded because they had hoped [to find water]; they came there and were bitterly disappointed. (AMP)
They were confounded because they had hoped; they came thither, and were ashamed. (KJV)