Do it OP, you won’t regret it.
Norfolk is an amazing place to bring up children in and for your budget, you could get an amazing property that can be a lovely little haven for you.
Honestly Norwich is very liberal with a big LGBT community, you’d absolutely be accepted. It’s a gorgeous city.
Sorry but I don’t fully agree with the while the more rural and Tory you go, the less likely you’ll be accepted.’ I’ve lived in different areas of rural Norfolk my whole life there have been people from all walks of life in every village and they’ve been accepted. Generally, the more Tory and affluent the village, the more educated people are and therefore more liberal/ accepting.
I live in a in affluent, rural village 20 mins from norwich with a population of only 600 people and there are 2 gay families and a black family. I mean you’d have to speak to them all personally to get their exact feelings obviously but I do frequently see/ chat to them all when walking the dogs and they’re always getting involved with village life and seem to know and be friendly with everyone.
And if you want to buy a big property that’s more isolated and not in a village then you’ll never really see anyone anyway. Do a good load of research on schools local to wear you want to live (Your children wouldn’t have any worries in any of the Wymondham schools for instance IMO) and go from there. Honestly though, it’s very easy for me to say this but I really would go for it. I know I’m biased but it’s such a safe, beautiful place to live and there’s so much for children to do as the city, broads and beaches are all accessible fairly easily from most places.
Good luck and I’m green with envy if you get either of those places 