Magnets won't affect photographic film at all.
Light, heat, moisture, and exposure to x-rays will affect film, however, so be sure to keep your undeveloped rolls (whether they're shot or fresh) in a cool, dry, dark place for storage. And make absolutely sure that if you fly, you don't pack your film in checked bags, or it will be completely ruined. Pack it in carry-ons, in a plastic ziploc bag, and ask for hand inspection at the security checkpoint so that it won't go through the x-ray scanner.
And I agree with Kaybracon - pound on your DH until he gives in! For vacation photography, digital is IT. In fact, most pros have gone digital, too, except those who shoot high-end studio stuff.
Digital cameras are more expensive than film cameras, but once you buy one, and a few memory cards, you never have to buy film again.