The wall is real and it is not about you. Hypothesis testing is where most books switch from explaining ideas to teaching a procedure, and the procedure is genuinely unintuitive when it arrives without motivation.
What got me through was reading two kinds of book at the same time. One narrative book about how statistics goes wrong in the world, which gives you the reason to care, and one working book where you do things with actual data. How to Lie with Statistics is very short, decades old, and still the best cheap introduction to why any of this matters. The Signal and the Noise is the longer modern version of the same instinct.
Then for the doing part: pick a dataset you personally care about, something like your own running times or your electricity use, and answer one question with it. The formulas stop being formulas about nothing and start being answers to a question you actually asked.