Ha! That is the same technique I use for existing tanks, and with the same disclaimer.
The 3/8 - 1/2" bit is awfully large, and reduces your root space while providing mulm collection spaces as djlen pointed out early in the thread. But the 1/4" and down should be okay so long as you stay away from the demanding low forground plants with tiny, hair-like or finer roots (lilaeopsis, dwarf hair-grass). Those are likely not on your list anyway due to the lighting.
It is not the easiest or best substrate, but accepting some losses and working with what will and does grow for you is do-able. The profile will help there also.