If trees only "transport" water, they don't need any? So why do they die when there's insufficient or no water at all?

OK, being sensible, so only a percentage is actually consumed by the tree but during drought conditions, the water is still being "pumped" in to the atmosphere and lost from the place where the trees are.