"Live Sand" like the ones from CaribSea are pre-packaged with water is "Marine use only" since the "Live" critters which make it live are Marine worms, crustacea and microbs. Unless they came out with Freshwater blend.
OohFeeshy Live Sand will not raise the pH unless it's "Calcium" based (again it's critters and microbes that make it "Live"). (most of the post I can agree with). It is waste of money if you buy it and used it for Freshwater application. Just get a bag of "dry" crushed Aragonite or Oolitic sand or Pool filter sand since it's a bit more uniformed and larger than play sand (in some circumstances).
Bignose you got some things mixed up here. (good break down in this site
http
/www.geocities.com/capecanaveral/han...icleHandy.html)
The area of "Plenum" in aquarium is a dead space of just near still water. I made my set up by using two sets of Under Gravel Filter Plates (only and no powerjet or filter) the whole PVC and Egg Crate and Window screen was too much work

.
The "trickle Filter" thing you speak of sounds more like "ghetto" calcium reactor or a bio-chamber (like a bio-ball wet/dry) if it drains from the bottom.
Usually the worms and burrowing critters in the sand, osmotic circulation and the NO2 gas from the bottom is enough movement for the Plenum.
In Freshwater one can still create a "Plenum". After all it's basically a dead space of water in near still condition. I'll agree it maybe rare to have such a condition in Freshwater (other than bogs and swamps).
Is it justified? Yes and no. It is justified for me since I had it all in place and didn't go and buy it

. Also the deep layer of Crushed Aragonite is nice

. Would I purposely do this set up again for Freshwater? Yes I think I would (or at the very least skim some of the "CA" out of the 125 to less than five inch level

).
I ran my 125 gallon in "My Modified" H.A.N.D.Y. method for dozen plus years (with a few tweeks). Then converted the whole thing (minus about 100 pounds of Live Rock) in to an African system with the Plenum still intact. I figured the Freshwater Microbes will colonize eventually and anaerobic under the "UGF" plates once again. Sure there aren't any starfish or worms that can colonize but one still can substitute critters for critters. One of these days I'll go in to my Cat Tail barrel and pull out Freshwater Gammeras and seed the system (they're also great treats for the fish). Even with my Neolamprologus Brichardi (shallow pits), N. Helianthus (who dug pretty deep pits and bred) is minimal for the vast acerage (okay it may not be that large but it would be if you were a fish

). Well, see if I have to do any water changes in my Freshwater H.A.N.D.Y. Tank (or not

).