You're asking a great question. I used to work as a professional trader and the answer is that probably nobody really knows. Like you said, any explanation you hear about prices moving is just a narrative fallacy.
People love hearing simple explanations to complex questions like "why did X price move" when in reality there is no such thing. The stock market is an incredibly complex interconnected system, with so many types of participants and algorithms optimizing for different outcomes over different time horizons.
Retail flow can certainly influence the market, but in my experience the influence is more indirect than direct, as algorithms may jump onto the retail order flow signals to profit from it, which may then create positive feedback loops. But who knows, the fact is that a lot of volume is being bought, and that's all you can conclude.
I'd go as far as saying that anyone who tries to connect the stock market with economic events doesn't understand a thing about trading. They're just not connected, except in a few special instruments. They're only connected in so far that people believe they are connected and invest based on that, just like Bitcoin is only worth what people believe it to be worth.