Everyone and every relationship is different so it is a tough call for us all. Here is my two cents.
If you stay off-site and he doesn't want to go to the parks, you are stuck at the hotel. If you want express passes, you will pay a lot as an add-on. Keep in mind, 3-day tickets are probably $20 more than a 2-day. You do not need to add express on that third day.
If you stay on-site and he doesn't want to go to the parks, he is left in a beautiful resort area where you can explore City Walk, entertainment and the other resorts without hassle. You could go to the parks alone and not be far from hubby. If you stay deluxe on-site, you get the express pass automatically, for every day. You can come and go from the parks to lounging around the resort. The third day ticket is still a barely noticeable up-charge.
I have planned trips for the reluctant and by going for the extra mile the recipient really enjoys the trip as a whole. Good luck.