It's been well-proven by Steam et al. that if you price correctly and use an unobtrusive (or even nonexistent in the case of GOG) DRM scheme, people would much rather buy and support their favorite games developers (and publishers) than go through the effort of pirating a title.
That's why games sharing would work with only minimal abuse. Not because it wouldn't be technically feasible for the consumer to abuse the system, but because the barrier to actually owning the games they want to play would be so low that it would become the new path of least resistance.
The sky's the limit if the industry can learn to treat their customers with respect.
Edit: By the way, a version of games sharing already exists on the PS3. If you purchase a game digitally on PSN you can install and play it simultaneously on multiple PS3s as long as your account is on each of them, I believe up to a limit of 5 PS3s.