Yes, a French drain has to drain somewhere. It cannot just collect water and stop, because then it becomes a wet trench instead of a drain.
In Houston, the pipe usually slopes toward a daylight outlet, storm system, dry well, or other approved discharge point. Without a real outlet, the system loses most of its value.
