My partner (40m) and I (30f) live in an area I hate and cannot move. Can it work long term?

I (30f) am a career driven girl. Prior to the pandemic I lived in the city in an apartment. I loved travelling, eating out regularly, nights out, galleries, museums etc. All that typical stuff. I met my partner online 1 year ago and I somewhat knew it might not work out because he is just really different to me. A country lad who doesn't like socialising and is happy to never leave his house. He has a kid and settled down young. That's the type he is.
Pandemic happened and I moved in with him in the countryside outside a small town.
I am really happy right now (with him, we are very compatible im every other way) but this life is never what I wanted or imagined. I hoped to end up in a near city suburb in a cool ish young area with things I like- good food, good coffee etc. Near attractions amd galleries so I can go out every weekend. I want to bring up my children in a cultured area and bring them travelling. I earn alot so all this is realistic.
I never wanted to end up in the suburbs or certainly not to end up in a small town. I feel alone here and I don't think I have much in common with the locals. FYI I am a foreigner and am living somewhere badly affected by coronavirus so I have had no opportunity to test it out.
Am I hyper focusing on superficial things here or am I going to end up miserable?
Tl;dr I am with someone who is location restricted because of their child. They live in an area I do not like so I don't know if our relationship is feasible long term


Source.