Chaotic Neutral Wreckage
A fursona isn't just a character they've written into a story but is actually them just in a different body.
I always found this concept extremely creepy, but that may be the 11+ year forum roleplayer in me talking. As with roleplay it was almost always seen as a negative when portraying yourself through a character due to how much drama and escapism (gee, whaddya know?) could result from it. It also made everything that happened with your character that much more sensitively taken, which in a lot of ways could be psychologically damaging for the individuals that didn't know how to separate themselves from their characters properly. While I'm not saying this mindset can't be done healthily - I am saying that it can be really difficult to stay healthy in the long run without any historical, psychological, or personality differences between you and the creation. The power of the mind is a strange, strange thing.
It's also very well known that a good handful of furries have issues with self-confidence and anxiety, so seeing a character representative of them in something NSFW could be a bit of a confidence booster.
This makes NSFW artists and NSFW commissioners everywhere look like pathetic anxiety ridden hermits, and I can only assume that the people actually doing this are few and far between compared to the ones who are doing it for the simple sexual fun of it. Mostly because a lot of Furries I meet tend to be functioning adults who are more than capable of flirting, chilling, and hanging out with fellow human beings. This misconception that "a lot of furries can't function so they use art to substitute" is honestly disgusting to me, and a little offensive to the community as a whole when you think about it. Then again, maybe I'm just being sensitive.
If seeing NSFW stuff makes you uncomfy then just don't look at it. The public and the normies will think whatever they want about us, no matter if we were all squeaky clean or not. Honestly, a big part of the fandom for me is not being like the public and just being myself.
Feels like you're missing the point that the OP is trying to make, but if his long rant didn't explain it to you - I'm not sure if I could either.