It would be even more unkind for people to say they are fantastic just to flatter you.
It is not unkind to tell you that photography, like everything, is a skill that must be learned.
It's not just about pointing and shooting. There's a lot of technical stuff to learn.
If you love photography then put your ego to one side and be prepared to learn how to do it.
There is no reason you can't become a fantastic photographer. You just need to be willing to learn.
I embroider. My first effort was absolutely shite! I was so proud of it and I loved doing it, but it was, objectively, nothing special. I didnt pick up a needle and become an embroidery goddess.
So I learned how to do it well. Watched videos, bought books, had a friend teach me more.
Now I sell embroidered pieces.
There is no reason you can't work hard and build up to making a career out of it.