For myself, I have extremely lofty dreams of becoming one of the best web novel writers due to how long I've been brainstorming and laying out my overall story. Of course, working on it for so long has led to times where I've felt hopeless and futile due to a lack of results from starting out as a nobody online.
Now for the transition, my greatest motivation is honestly to just keep writing and reading. I easily get fixated on works I love, so reading and rereading my biggest inspirations has made me re-realize the end goals I'm striving for. Meanwhile, simply forcing myself to sit down and write even just a few paragraphs of a chapter, even when I'm really not feeling like doing anything related to writing, can spark a similar sense of fixation on my own work, as I'm reminded of how far my own work can go if I just keep trying.
Shameless plug :3