It actualy doesn't mater very much what type of soil you use. All that is out there can grow plants what is beter is more of the users personal concern and experience than from the plants perspective. As long as the plant gets what it needs it grows on about everthing. Hence you buy a nice healthy plant in the LFS grown on Rockwool. That's melted rock spun into a sponge material. Its 100% inert and sterile and it has 0 CEC. Roots can penetrate easily in it and it drains and holds water very good while it stays fluffy and well aerated. The nutritional value is in the water non in the initial rock wool. Bacteria will come anyway and colonize in it to aid the plant.
In an aqaurium about same criterium can be used, if plant roots are able to easily penetrate in it during its development. Than the rest is up to what you put in the water column or additionaly in the substrate if form of tabs etc.
All soils with a so called buffering capacity all will stop buffering at one time because it will be saturated with all there is to buffer. It is not a catch and release on demand. Once it is depleted from all nutrients it will be as inert as everything else with or without CEC.
Than you need to act and add what the plants require to grow on.
How soon and how much it will be all depends on how much initialy is available and how much you stress the aqaurium with light and CO² and type of plants growing in it.
Low energy tanks in a proper biological pressure balance in stocking can grow years without any additonal ferts.
Higher energy tanks will need additional fert schemes to keep running properly.
Even tho we only use 2 terms High and low energy aquarium.. But there still is a quite a large range in between.
All can be achieved with any type of substrate available. The description on the bag is solely a commercial story for you to make you buy it.
Over the decades i've grown aqaurium plants on sand, gravel, dirt soil, akadama, lava rock and things i've forgoten. Al did it and i never found a reason to judge one beter than the other.. And if it didn't grow than the issue wasn't the substrates fault but mine.
My personal advice would be, choose one on practical and aesthetic reasons forget about the rest. Pro's and cons in substrate are mainly practical in my personal experience. How wel can it be handled in the type of scape planned.