Hi I've got the same problem, main dealer has quoted me £250 for a new barrel, that's assuming that the locks have never been changed, if they have then my key won't fit the new one, and I will be £250 out of pocket.
I'm like you, I would be happy to be able to open the door if the remote fails...