Yes, there was a really excellent post recently (was it OM47?) on... if I remember... using rainwater to mix in with tapwater to make a lower pH water to mix with high-pH tap water and bring it down.
One of nice tricks was to wait for a really heavy downpour.  What you do is get ready when the downpour starts and let it go for a while, washing the dust and other nasty particles off the roof and out of the gutter, whatever, then after a bit you fill your buckets and the resulting rainwater will often be nice and pure and lower pH, but you should test this with your good liquid-based test kits.
As FHM says, you never/rarely would want to use this pure, you'd be using it to make up a mix with tap water.  It should be tested after mixing too.
Its good to think of all the positive stuff coming in with tap water, especially the calcium, magnesium and and other trace minerals coming in in smaller quantities.  The fish need and expect these to match up with what they're used to.  The live plants need these nutritents coming in.. in fact, water changes of tap water can be thought of as a nice source of some of the nutritents plants need, although not necessarily enough of them.
And of course, as FHM points out, all of this is only necessary if you have a need based on a "pH or hardness problem" (typically) and depending also on your type of tank, type of fish and goals for the setup you're maintaining.
~~waterdrop~~