Interesting concept but there will probably be a very good reason why it's not popular in the hobby.
Goldfish are messy so if the OP is looking to keep his substrate clean without vacuuming, then this would work, to a degree, though the modern way of using powerheads to stir gunk up and getting rid if it that way is wayyyy better imo.
Your substrate would have to be pea sized at least and only a thin even layer all over the tank to ensure an optimum even flow upwards of water. Any undulation in your gravel layer and the flow of water would simply come up through the thinnest, ie, easiest route. Leaving the thicker layers of substrate to become clogged, which makes the whole concept pointless.
You wouldn't have plants with goldfish, usually, so no problem there. But how would this method work with plants? Your substrate would, if the method was working efficiently, be spotless and totally devoid of nutrient for roots.
And at the end of it all, you still need a good filter in your tank to take away the waste that is pushed upwards out of your gravel and into the water column.
I'm struggling to see any real benefit of this method. But keep us updated
S
Soni
on how you get on with it.
Oh, and welcome to the forum.