I unsubscribed by discontinuing my membership. Next e-mail you receive, check the fine print at the bottom, you get instructions on how to do this.
You're right, the program is horrible. The rewards are that you get a small discount on Sony CD's and DVD's which you can find much cheaper elsewhere.