In your OP question there is the answer contained in it.
"Do I hold any chance to make profit? Or am I being delusional?
Please, be honest, brutally honest... I would rather enjoy my time doing something else than try to polish a turd."
What I just did now, is because that's the way our "real self" (sorry for the new-age short-cut) tend to talk to us. It's there and we don't see it.
When you ask, please be brutaly honest, you do not ask this question to us but to your self. (the self knows, and the space I wrote between your and self is not a mistake)
If you had a chance, you would not doubt, it would not be an option. This thread wouldn't exist, even if you were just starting.
It would be clear for you that this is what you want and you'll do the necessarly steps, enhance technicals, artisticals, business aspects in order to reach your goal.
You would "work" really "hard" to get the level and knowledge to generate incomes, to YOUR own goal and your own way.
If you are not in that spirit, you won't be able to overcome the numerous obstacles that will show-up.
The problem I see it's not your work. I agree with amsp, but this is today and you could become a top photographer tomorrow who sells well. There is nothing that can empeach you except yourself.
The problem I see is that there is a lack of faith or interest.
More generally, strong doubt= no.
See this girl you met in that party the other day? if you have a doubt then it's not for you. Doubt and non accomplishment are one and the same.
You have probably more interesting things to do. The answer is in your own question. It's important to know how to read our subconscient messages. They have a lot to tell to us.
Maybe, just let this go, and will appear then what's behind the question and it can simply be to enjoy life differently. Keep it relax, you said it, you want to enjoy your time not following a mirage.
You said it, you feel liberated.