Writing is not exactly a lucrative gig at first. It's the curse of the arts, alas.
There are several valid paths to making a living. One is to work, essentially as an intern, in the lower markets and work your way up to the bigger markets and hope eventually they pay enough.
Another is to write and publish a good book. This opens a lot of doors, but it doesn't exactly pay the bills at first and maybe not ever. It's a big risk out of the gate.
The quicker and more-sure (though nothing in life and certainly NOTHING in self-employment is truly "sure") route is through marketing copy. Businesses pay much higher rates for good, on-target writing. And the timing is right: The rise of content marketing means good freelancers are in high demand.
However, a few caveats. The first is that you won't be writing about whatever the heck you please. It will be what the client wants and/or needs. The second is that working for yourself is just a hard gig and there's a huge learning curve before it starts to pay off. Oh, and the third is that writing marketing copy is not the same as just telling a good story. Good marketing copy is copy that sells... which is its own whole art. Storytelling plays a role, though, so there is that.
On the other hand, everything you learn about marketing will apply to selling yourself as an author. My path has been: Freelance writer to content marketing officer (i.e., I sell the content service, recruit & train the writers, and manage the business and the clients and the projects but don't actually do much of the writing myself) to novelist in not-quite-precisely-that-tidy order.
My novel is not yet sold. Heck, it's not even yet done with its first round of revisions. I'm not worried, though, because my business career pays the bills so I can afford to wait.
And everything I have learned in my freelance then business career absolutely applies to my novel. I feel I'm a better novelist for waiting until almost-40 to get serious about it.
By the way, I did always want to work in magazines. I even sold a few pieces into national markets. But like you, I figured out quick that the ratio of pay to effort was tiny, and channeled my energies elsewhere.
Best of luck to you!