Faltering at the primary level is one thing, but keeping motivated is something that affects all pilots at one point or other in such a demanding career field. You're gonna need a lot of energy to get over and through all the hoops, setbacks, challenges, and delays, but an honest self-inventory is always the best place to start.

When I was struggling with primary flight training I tended to work alone and I would do things to remind me why I was so interested. I actually only wanted a private pilot or instrument pilot license to begin with as a way to decorate my resume in other fields. No one thing was my sole source of motivation, being more or less absorbed in aviation all the time was the best thing for me. I would rent dramas with aviation themes, read the aviation magazines, sit at the field and watch aircraft come and go, take aviation pictures and share them, listen to my air band radio (a lot), do things for the college flying club, go to aviation museums, read the pilot forums, take flying lessons, watch the study videos, stuff like that. No one thing, just a lot of little things. After a trying time getting my private pilot and feeling the success of that endeavor, I fell in love with the process of getting flight tickets and really never quit until I had all of them. I saw each one as validation- more proof that I was worthy, useful, and admirable.

When you finally get your commercial you can start trying to fly for free or for pay. That's a shot in the arm, and it gets better with the CFI ticket as well. Having a regular performance outlet is a huge motivation to improve and grow as a pilot. I did skydivers, aerial surveys, glider tows, and teaching, all that was highly encouraging, so once you get your foot in the professional door you can grow much easier than when you are paying for each and every flight hour.

Hate to say it also, but if you really cannot get motivated and it seems like months between periods of being into the training game, this may be a sign flying is not your thing. There should be a point where the aviation bug definitely bites, so to speak. I know for me there was never any doubt I wanted to do it- I was smitten and there was no turning back at some point. I had a bad day every once in a while as does anyone doing anything, but the overall feeling was there was no better use of my talents and absolutely nothing I want to do more than to fly. And I tried a lot of things too- I did pro music, small business, several college tours, heavy equipment and construction, pro engineering, absolutely none of these was as good a fit to my needs as was flying an airplane. And at the risk of being immodest I was quite competitive at a couple of these endeavors, I just did not see myself doing any of them for multiple decades. Turns out I am a tad less than Chuck Yeager in flying itself, a tad maybe, but it fits my needs best of anything I ever did. You should feel about like I did about flying if you really want to be a legacy pilot one day and actually enjoy it.