We went from a town of over 20,000 to a village of about 80 houses. Talking to a resident who had lived there for over twenty years and she said she still felt like an outsider! We got to know a lot of people because of dh's job and were welcomed, but still outsiders after 4 years.
We found the countryside rather insular, if you weren't a native you were treated differently/with suspicion etc. Where we were there is still now a bit more racism than other places and even the town we are in in the same area can be racist.
Apart from a part-time shop in a nearby village our closest shops were 6 miles away, so if you forget something it's an extra trip to town or you wait until next on-line delivery or next scheduled visit to shops.
Our local school was in a village in the opposite direction so couldn't combine village shop visit with school drop off. School had about 56 children when we moved, over three classes with mixed classes. Only qualified for PP for one pupil an relied heavily on parents, locals, benefactors etc for extra funding. There was a lot of meddling from donators and parents and the heads job was more politician than head teacher/teacher.
Our village had no street lights or footpaths, and many drivers weren't careful. A friend with a new baby in a pram was nearly knocked over by someone going too fast, not far from the entrance to her own home. There can be a 'take it or leave it' attitude to legal matters too, it's unlikely you'll be found out so let's be relaxed about the law, depending on which area you're in.
Despite all this i loved where we lived, gorgeous place. You adapt to how you need to live. Massive freezer full of bread, milk, meat, veg, etc. Plan shopping trips around children going to friends etc (there is a lot if driving).
If you go to a tiny village you need to really want to go, research well and be prepared to fill your petrol tank up regularly. (And avoid the SW!)