I've not read the whole thread; here is my take.
Many of the women on here are in long term relationships
and their partners were aware prior to the start of relationships
or they were involved in the decision process for their partner starting escorting.
Two options.
My fav is the first.
1. Be open about escorting around your social group.
Any potential suitor (or stepping back, potential friend) will know your job
in advance of any consideration by them of a) Being your friend or
b) Romancing you.
In effect, all the head-work for them is done in advance
and you don't get to know anything about it, nor the angst overflow
2. Don't tell them for a while. At least 3 dates. This way they get to know you
without the escort consideration slanting things.
Then when you tell them they can have a considered decision.
I see you dated for quite a while before saying.
I'd suggest you don't beat yourself up; it was not to be.
One thing I would say is that you may like to consider telling future dates earlier.
This way neither of you will have made too big an emotional investment,
in the relationship. It will take the pressure off and may make a possible 'No'
into a possible 'Yes'.
When you are in a long term relationship and you fancy being single, don't blame me!