Some people think that breaking stuff is funny (or, in other words, they do it "for teh lulz"). It's possible there's some other explanations, of course - maybe they have an ethical objection to software piracy and think anybody who attempts it deserves to have their system wrecked, maybe the program attempted (or would have attempted, if given more time?) to exfiltrate your data (for identity theft or similar) rather than just delete it and nuking the boot sector was just an unrelated "make the nastiest malware possible" target, maybe the malware was going to replace your boot sector with one that ave very low-level persistent access to your OS and it was either incompatible with your machine or didn't have time to finish that task... Lots of possibilities.
There are absolutely no lack of malicious programs that combine wanton destruction with attempts to either gain money or send some sort of message (political, social, or simply an "I'm better than you" brag). Obviously for some common types of malware, like botnets including cryptominers, you want the target machine to remain operational; making it unbootable is contrary to that goal. On the other hand, if the goal was data/identity theft, preventing you from getting back online for a while may give the attacker more time to run amok with everything from your Amazon.com account to your social security number (or equivalent). I recommend changing your passwords and watching your credit score (or freezing it) for a while.
As a side note, antivirus is not a safeguard against this kind of thing. Antivirus is a last-ditch attempt to deflect the bullet you've already shot at your own foot, and it's not very reliable about it. If you get to the point where you think "if only I'd had a real-time AV running..." you've already screwed up, massively. Don't expect AV to save you. If the malware is old enough, and insufficiently obfuscated, and not bypassing the scans in some way, it will probably work, but it's like setting up a camera that does facial recognition of everybody approaching the house and checks against a police database. There's so many ways to avoid it...
Also, all versions of Windows released in the last ~10 years (so, the only ones still supported and receiving security patches) have built-in AV (with real-time scanning). If you don't want to use those, there are a number of free third-party options too...