There will always be a mix of active and passive.
Fundamentally - passive only works when it follows smart active. Actives do expensive research and trade against each other to arrive at the consensus price. Passives trade at that price for "free." Since both get the same price on average but passives incur no cost, they win on average
This breaks down if passives outnumber actives, or if actives are exceptionally stupid.
Imagine 100% is passive. That means any stock in an index will be bought tomorrow and forever regardless of price. I could exploit that in a ton of ways. For example, do a "squeeze" (think of the recent GME short squeeze but in reverse.)
Or, imagine company X will obviously default but stock keeps going up because passives are obligated to buy. Very easy to exploit by going active!
Finally - think about this. Does your index fund have any GME? That part of your portfolio trades at the price set by Reddit apes. The more of that goes on, the more tempting it is to go "active" on the other side.