"i realised this isnt a foght im going to win"
nope there are no winners here,
"and that he is actually having an affair with himself. "
That is an understandable feeling, certainly at the very least it is fair to say that he is putting his own feeling ahead of the rest of the family.
"How could i tell anyone. He made me promise not to say anything"
You have nothing to be ashamed of and owe him nothing in this regard, say whatever you need to, to whoever you need to, in order to get the emotional and material support you need to in place.
"How could he not talk to me. I felt sick and cheated"
You are perfectly entitled to your feelings. They are valid and reasonable. I would imagine that he didn't tell you before you married him and had his children as he knew this would make you change your mind. If he is now saying he 'knew' since he was 10 that would naturally make you feel like he tricked you.
"You wouldn't expect it if you saw him. The most manly man i know!"
His imagination is painting a very different picture in his head.
"he maintains he loves me and our kids"
but not enough to prioritise you and your relationships over the fiction in his head.
"and will never leave us."
At this stage that sounds more like a threat than a promise. In terms of keeping to the spirit of the marriage he already has left you, he just seems to think he's still entitled to you as a support human.
" but i pulled myself up and went home."
Nothing to say but <3 & hugs
"he started getting angry at our lovely counsellor when she tried to ask more in depth questions"
I do not think this marriage can be saved without significant harm to you and your mental and physical health. But I understand and applaud your instinct to try.
"wearing his sisters clothes and his dad beat him up"
these are his issues and he might benefit from counselling (without you) but he's been married to you for 24 years if you haven't fixed them yet you're clearly not going to, you need to get yourself and your children into a situation you can control.
"This is so sad."
I do not disagree.
" if he wants that life he has to go and we will divorce but keep amicable for the kids as id never atop gim seeing or having the kids. "
This sounds entirely reasonable to me.
"He wont go. No matter what i say he just wont leave."
It used to be possible to get assistance from the police in such instances I don't know if it still is, you need to call a DV helpline. Refusing to leave is on the 'lower' end of the spectrum but can cross the line into coercive control and from what you describe here that may well be the case.
"doesnt want to upset me any further but asked to dress up in private in the bedroom. "
Well he may well say that he doesn't want to upset you and yet he seems to be pressurising you into engaging in sexual acts you find uncomfortable and upsetting.
"He started nicking some of my lingerie without asking me and has pinched a wig i had for fun dressing up then used one of my sex toys and i got to the point where id had enough as made me feel right sick"
Respect for you, your feelings, your boundaries and your sexuality, seem to be notable by their absence. Consent is not just a mining village in Lancashire. This behaviour is not ok. Coercive control is a crime.
"Hes sh with money and has bought quite a lot of sex toys recently"
His priorities seem clear and consistent just (upsettingly) you are not among them.
"Im worried hes going to get us in a financial pickle again as we are joint tenants on the mortgage and he wont sign it over to me or even entertain it."
The divorce will be awkward and painful but you must separate your finances as soon as possible, seek legal advice as soon as you can.
"but i just close my eyes and wish it was over [removed by MNHQ] Im not a lesbian and i sure as hell wont change my sexual orientation to fit his."
You are not a lesbian and it is not fair or reasonable for a partner to force you to engage in sex that you are not enjoying. The sex you describe sounds like it is causing you sexual trauma, please stop.
"I'm miserable... he is miserable... "
I think you must (both) accept that if he wishes to substantially change his life in this way it will mean a substantial change in your relationship. You will no longer be his wife and sexual partner but a co-parent and if his behaviour deserves it, perhaps a friend. This is part of why people sometimes call TW "brave" . But explain he cannot 'have his cake and eat it' as it were. If it is 'only' a fetish, it is a fetish you don't share, and he can choose to prioritise you or it. Both choices have consequences.
"I dont want to be on my own either. I dont know how i feel about him anymore either as dont feel hes the same person i met in 1997 and i dont feel the same but got too much at stake to lose at the moment."
understandable but I don't think you have any other good options
" he leaves me to do 90% the chores so im only getting 6hrs sleep max a night."
Somehow 'dogsbody' doesn't seem to hold the same appeal as 'sex kitten', this isn't fair and I don't think that it's going to get better.
"To be honest id rather work a 10 hour day than have to be subjected to trans life... i dont want that in my life."
I think it probably will be hard for you to gain your independence and you may well feel you're working harder for a lower quality of life (than you had before) but at least you'll have a life, and a home you can feel safe in, and money that is yours.
"If there are other people out there who are in or have been in same situation please contact me. I could use some decent friends who understand what I'm going through and give me some advice."
check out the trans widows threads, many many women sharing their experiences of watching their oh embark on their 'stunning and brave' journey.