Even as draconian as Microsoft can be, I would be surprised if SP2 rendered your hard drive unusable.
When SP1 was released, Microsoft did increase checking for duplicate product codes and activations.
The SP1 "fixes" were limited to stopping the user from accessing Windows Updates.
I searched around Microsoft's web site a bit, and did not find any reference to changes to product activation in SP2.
That said, I would not be surprised if Microsoft has not further beefed up product activation and limitations.
If SP2 does have improved methods to detect illegal activations, you can be reasonably certain that the action will be limited to at most locking the system until the user acquires a valid product license.
The above stated, remember it has NEVER been legal to install ANY version of Windows or DOS onto more than 1 computer per license. Microsoft is fully within their legal rights to deactivate or limit the function of systems with illegal copies of Windows installed.
Further, the primary issue with SP2 for XP is that it does "break" many applications.
You should check with EVERY software and hardware manufacture for updates before installing SP2.
Chas