Honestly, I believe people shouldn't be pirating videogames at all. And most gamers actually don't. So nobody's going to hate them. On the other hand, I think no one's planning to do the same thing for MS Office in the nearest future, that would be insane.
However, it's important to always remember that a pirated copy doesn't equal a lost sale. Many people download a game, but never install it or play it. Others download and play it, but if they couldn't have downloaded it, they would never have played it. And finally, there's a percentage of downloaders that would have bought it if they hadn't gotten a pirated version first.
It will be interesting if this experiment by Ubisoft can determine how large that percentage is. It's definitely not 100%, and it's definitely not 0%. I would guess that it's a single-digit percentage of the people that would normally pirate a game that could go and buy it instead.
However, this new DRM is so vile, that they will also lose sales on it, and I wonder if the sales they gain from delaying the pirating of it is larger than the sales they lose from having a horrible DRM.