Yeah, the "with all due respect" precursor usually means they're about to insult you, too.
Not always, unless you consider disagreeing an insult.
BTW, what does "sod off" mean? Is that like sawed off? Sorry. I'm not familiar with that term as they never used it where I came from.