There's no shame in that. Most people who like playing chess will never
be Grand Masters. Most people who like playing baseball will never be in
the Major Leagues. Most people who took drama in college will never be
professional actors. Most people who like politics will never be
Congressmen, Senators, or President.

I make those comparisons for a reason. It's not just that those fields
have a similar attrition rate to writing fiction (ratio of people who try
vs. people who succeed). It's also that in all those fields, responding
to an initial failure by trying much, much harder generally doesn't work.
Infinite willpower and refusal to give up aren't going to get you into
professional baseball if you're 5'3" with bad knees. They just aren't. A
certain level of natural talent has to go along with all that hard work.

(People make the opposite mistake too, of course. "I have a real gift for
X. Now hand me my success, don't expect me to lift a finger toward it."
Fails for the same reason -- there are people out there with both talent
AND practice, more than enough of them to fill all available slots.)

Another thing about those fields I compare to fiction writing -- none of
them is The Only Way to Be A Successful Person. Nor is getting a novel
published. I suggest trying some alternate careers and hobbies.