When drawing for yourself, drawing what you want to draw is always the best option.
When drawing for others, if you are doing work that you believe in and want to create it seems that it’s easier to stay motivated and happy with your work.
But at the same time professionals do the work that they have contracted to do, because they’re professionals. You can still decide which themes you will and will not do for hire, and decide which contracts to accept and which you will not do. But you do the work because you’re a professional, not because you want to draw that thing.
Some people split the two - they have “This is the art I create because I enjoy it” and “This is the art I did for work”. So you don’t have to have just one answer.
I guess what I’m saying is if you want to do different kinds of art professionally than you do for yourself, just make that decision. You can use a pseudonym for your pro work, if that helps.
For me, if someone hires me to do work for them, and if what I draw for them is something I don’t want in my personal gallery, then that art is theirs, not mine. I get the money, they get the art. And if someone asks me “Did you do that piece?” I can say, “Yeah, that was work for hire for that company/person”.
I know that there are really good reasons for not signing over your copyright like that, but for me if the piece is not something I want to carry with me I treat it like writing code or writing copy - they pay me for the work, and then it’s theirs. And I charge more for it than if I was creating something that I would own and they would lease or license.
So, if you want to draw more and are willing to take NSFW commissions, then make that NSFW art something you are doing for hire, make it a professional thing. And keep doing the work you love to do for yourself, and keep them separate if it helps.
You still get to decide what you do and don’t draw, and if someone says “Woah - you drew this NSFW thing?” just say, “Yup, that’s some of my professional work. If you like that, I can do one for you too - here’s my rates.”