Do you like writing?
When you're starting, it might be challenging.
You'll struggle to tell your story and get it on the page. If you accomplish that, there's feedback and rewriting, which is also tricky. And to find success after that requires marketing and selling (don't get me started).
But all of it is worth it if you like writing.
It may seem like an obvious point to make, but a lot of people like the idea of being an author, being published, and having the next bestselling franchise—but they don't want to do the work.
And that's okay. You don't need to. But be honest with yourself.
Do you like writing (and editing and selling and on and on)?
Because if you do, then stay on the journey, no matter the outcome. And if you don't, then don't stress. There are plenty of other things you can do. You just have to find it.
PS - You can still write even if you don't want to make it a career. But do it for fun. Life is too short to do things that make us miserable.