Yes, check out Emmie's links in my signature for a nice collection of my best stuff... and also check out my current grow that is just wrapping up, the berry d'licious... in that one I did a little experiment.
I just saw that light bulb come on over your head and you now grasp the concept... and my grow there illustrates what can happen. It is turning out fantastically too by the way... But in that grow I started out with a strongly mineralized supersoil and then other than a supplement I am testing out, I did not feed these plants one molecule of food. They got water and microbes... that is it. No top dressing, no foliar sprays... zip, nada, nothing. The microbes do all the work for you if it is already in the soil. And every grow doesn't have to start out with brand new amended and recooked soil either, you can easily get a couple of grows in large containers. I wouldn't want to go multiple grows with 3 gallons of soil, but 7 and 10 would be easy.
So yes, with a good soil all you need is microbes and water.... and you mentioned compost tea, but keep in mind that every compost tea is different. The goal with a tea is not to create a nutrient rich soup that can be used to feed the plants, what you should be doing with a tea is something completely different. You are designing a particular tea to be populated with the exact microbes that feed on the exact nutrients that the plant needs at that time. Early in veg, you want the nitrogen hungry critters teeming in your tea, and you really don't need any of the others. Later, you will want the workhorses that feed on iron and potassium and phosphorus and calcium to be the most prominent ones in your tea, and the way you make this happen is to create brews that have small amounts of those exact foods in them. If you supply the food, the targeted microbe will thrive... all others will not. Making a tea is a balancing act, and one you can control with exactly the right inputs. Again, those inputs are quite small and you can not and should not expect your teas to supply nutrients to the plants. This is not their purpose. Everything that plant needs is in that soil already... you just need to workers to go and get it and supply it to the plants.
So throughout the various stages of growth, there are teas that specialize in what is going on in that stage. When I brewed my own teas I had recipes for each of these stages, early and late veg teas, a bud inducing early flowering tea, a strong flowering growth tea and a finishing tea.... These were my staples, and each one was brewed a little differently and with different inputs, simply designed to bring in the specific microbes needed at that time.
My last grow's main experiment was to make that whole tea process a lot easier and more efficient. I used a product called RealGrower's Recharge, which is a freeze dried collection of very specific microbes for every stage of growth, complete with small amounts of their food to get them going, in an easy to use mix with water system that essentially gave me instant compost teas, with much stronger populations of microlife than I could ever brew in my home AACT system. I ran this whole last grow on old worn out supersoil that had recently been amended, water and recharge. Nothing else was needed.
Now, regarding your teas. First of, the worm juice is wonderful stuff and just full of all different sorts of microbes. Consider that muck the seed that starts your compost tea. Compost is also a good source of raw microbes and is often used to start the tea. It however is not a specific tea and this is why it does not work as well as a carefully constructed tea, because what you have in there is a battleground. All the little microbes are competing for food and some of them even eat the other ones. If you get too much of an aggressive batch of protozoans, or even worse, terrors of the amoebic kind, huge numbers of the beneficial bacterium can be wiped out, leaving you with nothing doing the work you need done in the soil. Then there is the matter of your tiny air pump. It is not nearly enough to do what needs to be done, essentially moving so much oxygen through that mix that the bad stinky anaerobic microbes, the ones that thrive in a vacuum and places without oxygen, can not survive. You attack them right out of the gate with huge amounts of air, and right off the bat you end up with only aerobic bacteria... almost all of them beneficial. Brewing a tea without enough active aeration is not very beneficial to the plants, because again keep in mind that the whole reason you are doing this is to supply microbes... the correct microbes... you are not directly feeding the plant.