In planted tanks, laterite can be used at the bottom. I've never seen tanks with laterite only or on top. I assume it will be messy..... like nature.
Pond
potting soil can be pretty messy also, hence in ponds they add stones on top, and in aquaria they add
sand or gravel on top. I've briefly kept a pond potting soil only tank and it was not that bad. I assume mixing it with
aquasoil, it becomes more fixated, but....very dark. The soil of tropical Thailand is more iron-red, but not that different from soils in other tropical parts.
I think you should find individuals online in the USA who sell "red colored sand".
Tannins....are actually humic substances and not so much tannins. Humic Substances are organics that develop when dead stuff decomposes. Like minerals (inorganics). This is not so easy to orchestrate. The easiest way is adding dead stuff that comes with humic substances; wood, dead leaves, botanicals. Rooibos tea is extremely effective with
water changes.
Lake Bung Khong Long, Bueng Kan province, Thailand, 54 L – Biotope Aquarium
Not really that red either. On a smaller scale, you'll find plenty of variation in any region.
I'm sure the creator added plain sand, or different sands, and lots of leaf litter, both crumbled and in original shape, added lots of grasses and called it a day.
I'd buy different substrates in small volumes and experiment in different small tanks or occasions. You could
test the water.