The more people that do index funds, the more opportunities exist for day traders (or rather, individual stock pickers).

The inverse is true - the more people that stock pick, the more opportunities exist for index funds.

So, yeah, there's definitely a balancing act between the two.