I think your feelings are valid but the fact is Carson is grifting for cash. I can believe his conflicted emotions are real but that doesn't change his conduct or the bigoted views he proselytizes.
I personally don't shame sex work, even when it's very mild like the stuff Carson is comfortable making right now. I have a "Firefly" view of sex workers. They should be appreciated and respected for the service they provide because we all need a little release and if someone is good enough for you to get off to, then they're good enough for you to show respect toward as well
As for his content/bigoted views, I think there's nuance there as well. Yes, his views are that there's something wrong with being gay, etc. I get how that feels bigoted to people in our community. But I've also spoken with lots of religious people who believe being gay is a sin and
1. They are products of their environment. Any one of us could've ended up holding the same view, given the right circumstances
2. A lot of them are actually just concerned because they believe you're putting yourself at risk for burning in hell and they have been taught that they can save you - and that it's their duty to try to do so
This is why I fully understand and empathize with anybody who doesn't want to try to meet someone like Carson where they are in life. It's perfectly valid to say "nah, fuck that guy for being against who I am," I just think it's a little less black and white than that. Of course, some religious zealots are just using religion to justify their hate. Based on my interactions with Carson, I think he's not that type. I think he's just doing/saying what he's been taught and what he believes is morally good. And there's some level of respect I can have for that, even when it's directly opposed to who I am.