I told my children when they were 15 and 17. As a single mum, it would not have been possible to keep it a secret, although I told my eldest first. I’m no good at sneaking around and there would have been too many questions.
They were both fine about it but tbh, I didn’t give them a choice as I was moving from a toxic work environment that was affecting my health.
Fast forward and they are completely accepting of what I do but we don’t talk about it, apart from where I’m going on tour etc. They see my role more as a sex therapist, which is pretty much what I think prostitution is, albeit hands on! They are still at home although one of them is moving out next year.
They have both acknowledged that they wouldn’t have had the lifestyle they’ve had if it wasn’t for my choice of job. Whilst I realise that keeping the secret might have been easier on them, I’m just not very good at leading a double life.
That said, other family members do not know but since I don’t have that much to do with them, I’m not bothered. My mother knows and has, from day one.
If I had a partner who was able to cover for me and share some of the burden emotionally, I likely would have managed to keep it a secret (a bit like MI5

)
What it has led to is completely honest communication with my children and they see me as very open and approachable (they will even discuss their sex lives or ask questions) so it’s worked out well.
They also realise that the sex industry is far reaching and not just Only Fans etc, that not everyone is a victim and that normal women choose to make their livelihoods this way.
This is only my experience but it’s been a positive one.
(This was about 12 years ago)