How much of this is just nerves? I went back to work a couple of years ago after nearly a decade out and the prospect was terrifying - I don't think I'd realised quite how much my faith in my own abilities had crumbled during those years at home.
So is this about that, or is it really about the details of the job? Presumably whoever gave you the job thinks you have the ability to do it - and if you try and it's awful, well, at least you tried and you'll have got past that initial back-to-work hurdle.
In most instances I would encourage someone to take the opportunity back into the work place. However, I do wonder if it will dent your confidence rather than help to build it. You need to feel as informed as if not more than your audience and things have moved on so much esp with the growth of with social media since '05.
Having said all that....where does being a tutor it with your longer term plans? Being seen to be a tutor could be great thing to add to your CV.
So if you want to go for it ask for the slide deck to see what it covers (the fundermentals of marketing are still the same)? Get yourself signed up to social media channels and marketing e-newsletters and maybe start attending some industry events to plug the gap/feel current.
I agree, this sounds like it could be a bad experience for you - and for the sake of two days' work, it could be extremely stressful. I think rather than doing yourself down you are correct in that your skill set doesn't match the requirements of this job. And the fact the college is going through tutors at a rate of knots is a very poor sign as well.
If this were a job that you really wanted but you were having a wibble about, I would absolutely say go for it and don't doubt your abilities. But I think your caution is well placed here. Keep looking - the right kind of work is out there for you.
Sounds like a great way to get back into work. When do you start?
Btw I subscribe to the free daily e-news from e-Consultancy (I don't work from them honestly!) I find it really good and highlights trends in marketing in an easy format. It sounded from previous posts you might want to look at ways to catch up/stay current.
So pleased for you. Love it when things come together!