I'd say I agree with your summary of it honestly - From personal experience, and from talking to other female artists - most of them generally get into it just because they like art and it's where the big money is. Typically through anime or manga interests.
For the ones who buy rather than create, it's more of a way to express themselves, different sides of their personality, different emotions for the most part.
The most common type of pieces are "pin-up" style pieces, these can either be clothed or nude, it's about 60/40 ratio at a best guess.
Though that being said most clothes are usually lingerie, undies, beachwear etc. They more give the vibe of "empowered in their sexuality" rather than provocative though, they're generally more artistic. I think aesthetically the pin-up style is just popular.
A lot will also commission or create "vent" pieces, where you're capturing super extreme emotion/crying. Some extend into self harm or showing cuts/drinking/smoking weed etc.
Some will commission wedding themed images or just cutesy "couple" images - I remember one I was asked to render in a "Flying spaghetti monster" in the night sky looking all ethereal, that one was wild ahahah :')
Then there are also some who, I don't know if they can't have families, or if they haven't found the right person yet or what, but they're suuuuper family centred and will create "fursona's" for their entire, solely online families.
They'll have husbands/wives, children, sisters, parents, grand parents, the whole shebang - All just other furries they met online roleplaying being a family.
Then ofc there's the relatively small subset who just want sex stuff, I genuinely feel this is older teens/young twenties people who generally just have high sex drives.
However this tends to fade away as they get older. Commissioners who would once want only NSFW work from me over the years gradually wanted more SFW stuff, until they didn't really get NSFW stuff at all anymore.
I could post some of the SFW stuff I've done for people if you'd like to literally see what kind of thing they'd commission?
I genuinely think it would floor people to know how much money furries have to throw around on a whim, and how many are in positions of power or working at super well know companies relatively high up and on high wages.