Goodberry says "... the berry provides enough nourishment to
sustain a creature for one day."
Nourishment is not a game term so it takes its normal English meaning. The OED defines nourishment as "The food necessary for growth, health, and good condition" and food as "Any nutritious substance that people or animals eat or drink or that plants absorb in order to maintain life and growth." Water is a "nutritious substance that people or animals eat or drink ... in order to maintain life and growth."
In summary, a Goodbery gives you what you need to stay alive for 1 day. Whatever that is.
As an analogy, in a cold climate you need more kJ per day than in a hot climate to maintain body heat - those kJ are "nutrition" - does this work or is Goodberry only good in temperate climates?
As a game mechanism, Goodberry is serving exactly the same role as the rain catcher - it is draining party resources. For the former that comes in the form of a 1st level spell slot, in the second, in the form of treasure to buy it, time to use it and the risk of exhaustion when it doesn't work. For low level parties the spell is a serious investment and the rain catcher isn't: for high level parties the calculation changes, however, raw survival is rarely a concern (or a fun thing to play) for high level parties anyway.