I would say yes. Most incompatibilities with existing hardware's drivers etc are easily sorted out, & the extra security that SP2 gives is well worth it.
If you look at some of the recent threads on peoples' machines being accessed by spammers or worse, any extra help in keeping your computer safe is essential.
The only problem I had putting SP2 into 2 machines was having to update the software for Nero on one.
However, it's up to your good self.