Based on a four day visit to York, I think its city centre should be a model for Oxford's. York has pedestrianised a huge chunk of its centre, and it's really great to walk around. After a bit it just feels entirely normal, just as it does in similarly pedestrianised European cities, and it really shows up just how horrible walking around central Oxford is.
At least during the daytime, outside loading hours, there are no cars at all, moving or parked in the core area of York. This means that one never has to think about traffic at all, or even about getting around parked cars, which makes for a completely different feel to bits of Oxford such as Catte St or Turl St or New Inn Hall St or Merton St or Pembroke St, where anyone walking is likely to encounter at least one moving motor vehicle and many parked ones. (Oxford streets such as Pembroke St and New Inn Hall St may be more nicely surfaced than most of the York streets, but that just demonstrates that removing motor vehicles is much more important than attractive designs in changing the way people experience and use streets.)
Oxford visitor satisfaction in the 2018 Visit Britain destination report was 39%, versus York's 57%. And that was before the footstreets scheme!
The restrictions vary, but the core footstreets have loading 8-10.30am and no vehicle access 10.30-7pm.
Improvements
There are concerns about the pedestrianisation for people cycling and blue badge users.
It's hard to see how fitting disabled parking inside the footstreets area could work: these are narrow streets with high volume pedestrian flows and even low numbers of motor vehicle movements would be detrimental to them, even if space could be found to store a few cars. There is blue badge parking on the periphery of the centre, in Duncombe Place and in the Coppergate Centre (which provides a Shopmobility service) and those could be expanded. Some provision towards the north-east might be possible too, though that may conflict with resident parking.
Cycling is similarly difficult to fit in, but there needs to be at least one NW-SE cycle route through the city centre, possibly on Parliament St (where there's plenty of width) and Blake St. (I thought of that route myself, before finding that York Cycling Campaign had proposed just this.) Bridge-Pavement-Stonebow is clearly intended as the E-W cycle route; there's even a very short wand-protected stretch of cycle track.
I don't see any reason not to extend the footstreet restrictions to cover the whole day, with a few hours in the morning and evening for loading access. That would allow removal of all the kerbs and double-yellow lines, and layouts that are more attractive and more accessible, especially to wheelchair and mobility scooter users.
Ouse Bridge should be for pedestrians and cycles and buses and taxis and access traffic, with no through routes for private motor vehicles inside the walls. That would allow the area around Micklegate to be de-motorised and help connect the west bank with the rest of the city.
The more residential areas inside the walls are already low traffic neighbourhoods with 20mph speed limits. The whole area inside the walls should be 20mph, and the carriageways there narrowed as much as possible. Walmgate, for example, should be 20mph and its one-way stretch could be narrowed to 3 metres, allowing for wider pavements. The inner ring road running around the walls should be made 20mph too, as it needs to be crossed to reach many destinations and is hard to avoid when walking or cycling. (Even better would be some kind of city-wide circulation scheme that took private motor traffic off the inner ring road entirely — that would open up a huge range of cycling routes but also enable a significantly better bus system.)