I'm not sure I'd say a 10-second drift is common for a single song, that sounds screwed up to me. I sync a/v all of the time, and there's no doubt that is a lot. And, considering it did NOT happen with the other songs, that is even MORE strange. Are you absolutely sure there isn't a long dropout in the audio or in the video?
That said, will above has it right. Typically, you'd sync up the head (beginning) of the a/v, then move out to the tail (end) and stretch/compress (not compression like audio compression, compress like squish it shorter in length) either the audio or the video. Now typically, I'd stretch/compress the audio so it syncs near the end because it usually is only a few frames/secs off, which can be easily handled on the audio front without pitch problems in most apps today. I say this because compressing/stretching the video will cause more noticeable quality issues in all likelihood. However, when you're talking a full 10 seconds, that's pretty bad, and makes me wonder if stretching/compress the audio will be audible or not (even with an algorithm that holds pitch constant). You'll have to listen to it after it's been stretched/comrpessed and then decide. If it is audible, you might decide to leave the audio intact, and stretch/compress the video instead. But the main point is this: (1) sync the head, then (2) stretch or compress either the audio or the video's time length such that the tail also gets into sync. Then, hopefully, the entire song will have sync (unless you're using analog to tape, in which case tape speed changes can screw things up, but I'm betting you're using MiniDV, in which case that shouldn't happen).