I am truly sorry for you after reading your post carefully , you are certainly not a fool.
I have lived here 20 years now in Thailand and I was until 2016 very proud to have not been caught by one of these types of Thai women.
Then like you I fell in love with one of them , unfortunately my story ended up very badly like yours. Its not a nice thing to go through when you realise that you have been lied to for years and it really messes you up emotionally.
To make you feel a little bit better , dont be hard on yourself , you have done nothing wrong , it's her who is the problem , we just got fell in love with the wrong type.