What appealed to you about Oxford as a child?
I loved the idea of the history of Oxford/Cambridge, the traditions, that so much science or other discoveries had been made there, intense discussions with experts in old studies, staying up late talking about important things with other students, the beautiful buildings and scenery, the idea that it was college based and people lived in, and it would feel a bit more like the boarding school I wanted to go to but never did - full of close friends, getting together in each other rooms, the camaraderie, etc.
But I went as a post-grad. And it wasn't like what I expected at all.
Well no, maybe some of it was. Some of the traditions, and the beautiful buildings. But much of the time, I envied the undergraduates for what their experience was. I felt older (even at 23!). I wasn't part of the close-knit groups. I joined music groups and societies, but I was a bit of an outsider. I wasn't part of a 'Year' group at college. I didn't ever live in the college grounds.
I did enjoy lots of it. I made friends. I liked being part of a college, as that was at least better than being out on my own in a random big city trying to work on a PhD in isolation. I did like the history and feeling part of a great tradition. I went to talks by experts. But it was still very very different doing a post-grad. It's more isolating, you're an adult in a different way, you're not part of the main mass of college that it can seem like the college cares about, you are more connected to your department than your college. It's a hell of a lot of work, very self-driven, no classes, no assignments, nothing but a giant thesis by the end of it.
If what you really want to do is the research, and you can get a supervisor there who is a good fit, then it could be great. But still very different to what you might be imagining.
People do ask where your PhD is from, so it's not true that the location has nothing to do with it, especially if you don't go on in academia. If you do, then who your supervisor is, and what research you do, is more important.
A 2:2 isn't the end of possibilities, but it's not great. You'd have to show that you'd be able to come up with and carry out a decent project for a PhD proposal, and have to convince a supervisor to invest their time in you doing that. And then you'd have to get money to do it - the 2:2 would be more problematic there, as it's so so so hard to get funding already.
So I think you need to really think about what you want from the experience, and if there are other ways to get what you are looking for, or you might still end up envious and regretful throughout your time there.