I'm still waiting for someone to show me an example of when a sand substrate went anaerobic and killed their fish.
Until then I remain convinced that it's just an overblown paranoia.
And you don't need to vac to prevent it - all it takes is a little stirring with a stick or a some sifting with your fingers every week or so.
Any plant that isn't heavily rooted requires no specific substrate at all. And most heavy rooted plants do perfectly fine in sand. In fact some of mine have done better in sand than even in those "plant" substrates. If you ask my opinion, it's yet another in the series of bs found in this hobby. Remember this always: there was a day only a few decades back when most people were led to believe they should never change their water. Something to keep in mind.