Might (Very big might) move there for Dh's work. I've been briefly for a few hours and it seemed very pretty but with nothing to do and nowhere to go unless you wanted to drive for at least 30 - 60 minutes. Used to somewhere a bit more urban. Anyone?
Floods occassionally. Has very nice castle, steam railway very expensive. Realise first point is only one with any relevance to living there but they were the first three things that came into my head about Pickering. I'm sure someone more knowledgable will be along soon.
My impressions are much the same as yours, Bruno: Pickering is a place to drive to on the way to somewhere else. Unless your DH has a job that requires him to be actually in Pickering (like being a fire-fighter who has to live within 5 mins of the station) I'd be inclined to live elsewhere commute - either the coast or York - it's about 40 mins from Whitby, which is lovely (tho' still small and expensive), Scarbro' (which is fun, a larger town and quite a bit cheaper), and York - which is a great city to live in.
If you have to live specifically in P, this website might be useful.