I spend far too much time thinking about and building code for trading on betting exchanges, which isn't quite the same, but there are parallels.
Most experts agree that the hard definition of efficient markets (that all information is baked into a price immediately), doesn't hold, but the soft definition (that the price will veer towards true value), does hold. The big question is how quickly does it get there?
That means there is potential to make money (if it takes n minutes, and you are able to trade at n/2, and exit at n, you're going to make money). Insider traders can make the most money, but there is also money to be made on much longer trends too, I think.
Most of the super smart people throwing money at algos and hardware are specialising in HFT to try and trade at very high speed. They are typically not looking at much longer trends. That means there is perhaps more exploitable value for the individual in longer trend spotting compared to shorter term trends. (Note, I don't mean technical analysis when I talk about trends.)
Would I recommend you get into market making and HFT? Not without an eight figure sum to get started.
Would I recommend you get into value investing and looking at the long-term? Sure, just remember that diversification is good for a reason, and you might struggle to beat an index - most professionals do. If you enjoy it though, you might find it a good way to make your retirement savings grow, perhaps even a living.
Would I recommend you get into day trading? Probably not, but that doesn't mean there aren't successful day traders sat at home making a living trading on margin. It's hard work, and if you're smart enough to make it pay, you're probably smart enough to make more money doing something more productive for society instead.
I also don't think most people are smart enough to make money (important note [1]), if they try and work out by "thinking". Don't try and move from first principles. Learn from successful people, who aren't full of BS. The vast majority of people on YouTube and selling books are not successful. There are real success stories out there, you need to filter a lot to find them, but they exist. Use them.
[1] Your question was if people can "outperform" the market. You don't need to outperform the market, you don't need to be optimal, you "just" need to make enough money to meet your goals, and preferably more than you would get just from leaving your money in an index tracker. That's not the same thing. If you're trying to perfectly enter/exit trades and "beat the market", you're dead before you get started.