It may or it may not work correctly with SP2. You might be able to figure that out ahead of time by reading the technical specifications for a particular drive on the web site. If they've done a decent job, they should have something like "needs XP-SP2" or "SP3". Or maybe even does not work with Windows XP.
Of course there's the old try it and see if it works - trial and error.
As background,
here is a discussion from MicroSoft about problems with DVD. Note the different sections including the one for XP. Some of the diagnostic repair steps are what you might need to do to get it to work.