From the standpoint of a naturalist, it's a very bad idea. I've been out on several trips
With the local museum (Cleveland) taking old drainage systems out of woods to benefit local plant and amphibian populations. That stagnant water you're speaking of Is vital to amphibians such as spring peepers and spotted salamanders.
Most authorities now agree that water should be left to permeate the soil wherever possible. You can only do harm in draining healthy soil, as has been shown in decades of soil erosion research.

From a pond standpoint, give it a try, though the water might be high in nutrients of its surface run off, as opposed to soil-filtered.