Hammie is 3 yrs old and STILL to this day has a field-day with toilet paper. He'll lay on the floor beside the Throne & bat at the tp, watch it roll a little, then catch it with his claw, and oops... off he goes!
I just laugh, I think it's funny. He doesn't do it every day, just when he's in the bathroom with me and he's bored.
There ARE weights that are built in to certain tp holders. Just remove the tp holder that you have and put one of those in. It has this flap-thing that lightly clamps down on the tp so it doesn't fold up.
Another idea, to deter kitty from seeing that tempting dangling piece of TP; just tuck the edge of the tp under, in on itself, like they do in fancy hotels? You just give it some slack & tuck it under the roll. It's not that much of a pain in the butt.
Please don't get rid of your cat because he has a fetish for TP.
Also if your hubby didn't want a cat in the first place... he still has around-about 17 years to go, of living with this cat. There will be other issues as the cat ages. Maybe you could find kitty another home? I have known way too many cats who existed in hostile homes before they found good homes (see my babies below) who were kicked to the curb for reasons like this.