To bring this back to the original request, I'll offer this as a long-time educator: motivation is a mixture of having a goal that your are enthusiastic about and have fun doing. There are many short-term goals and easy wins you can use as markers to denote your progress and maintain your enthusiasm as a budding pilot. First good landing, mastering steep turns, gaining confidence in slow flight and stalls, first solo, first cross country, passing the written exam, etc. There are lots of early wins and good guideposts to progress all the way to the checkride. You will have to do your homework (hitting the books on aerodynamics, systems, weather, navigation, and procedures) as well as the physical tasks of flying an airplane. The homework is not busywork--it is essential for flight safety.
Flying, like many worthwhile endeavors (like learning chemistry or becoming proficient at a sport) is challenging, requires persistence, and patience to overcome inevitable obstacles. (If it was easy, everyone could do it.) If you find yourself quitting when you encounter challenges and obstacles, you should really examine what is driving your motivation. Why do you want to be a pilot? Is it fun for you? Do you enjoy challenges?
People rarely fail at things they enjoy and/or are important to them. If you do not enjoy flying, then you should re-evaluate why that is so. Flying, like sports, or chemistry for that matter, is not something you can learn online. You need to be engaged in the real thing in the real world. (I've watched a lot of figure skaters over the years, but I can still barely ice skate.) An instructor is essential to ensure that you are practicing good technique. (Practicing bad technique by yourself is another way to set yourself back. This is how my student athletes torture me as their coach.) If money is an issue to regular flying, I would recommend saving your nickels until you can complete a stretch of 75 hours or so of flying in a 6 month span or so. If you spread out your training over a long period (say years), you will spend twice as many hours learning half as much. I think 4-8 months is a good target for efficient progress toward certification. (You can go faster, but that has other learning issues.)
I wish you the best. If you want to fly and have fun doing it, you will succeed.