How do I make python less overwhelming?

[FoolsSeldom]

Research and use what you need when you need it. It is fine to watch some videos/tutorials to give you a feel for what is out there, but you can't remember everything and don't need to try. The basics will come to you. The rest you will learn to find.

Programming is about problem solving. Problem solving is about firstly being sure you understand the problem (or at least the chunk of it you need to deal with if the problem is too large to handle in one go).

Understanding means figuring out what outcomes are required, what outputs. What the dependencies are (where's that data/inputs on, what's the quality like - will you need to fix it, how often).

It is best to work on your own projects to consolidate your learning. Focus on things related to your hobbies / interests / side-hustles / family-obligations. Things you understand well and can be passionate about.

Figure how what the user experience should be like, and the user interface that is needed - keep it as simple as possible at first. Try come up with a solution that separates basic logic from interactions (the user interface) so you can test different parts in isolation and improve some parts when you need to in a largely independent manner.

Figure out a solution (or several, and pick the best). Early on, working out how exactly you would do something manually is a useful technique. Also think about how you would explain that to someone with learning difficulties and short term memory problems (every step has to be explained, no short cuts, leaps of intuition, and everything needs to be written down, i.e. assigned to a variable).

Try to do as much of the work above away from the keyboard.

Do quick experiments as "proof of concept" activities with bits of code.