Rebecca Norlander gives a highlevel overview of XP SP2 for an end user. The video is posted on MSDN's Channel 9.

The direct link to the video feed is here or the posting on Channel 9 can be found here.