Dude, you couldn't have known. I know it's hard, but you shouldn't dwell on it
You did everything right, it just wasn't the right time or the right person. You're not to blame at all - if it was an issue on her side, she should have talked about it instead of coldly friendzoning you
Just to be clear, I asked my wife what she thought, and she thinks the same thing
People in this thread seems to live near big cities, which isn't really representative of the whole european population.
I live in rural france, the closest grocery store since I was born is 20km away (20min drive, no bus), and I moved 3 times - still about 20km.
Lots of people I know would love a store to be 3km away