For me, it's definitely a Love It!
Your husband's not wrong in that the game sets you against waves and waves of enemies, all Warriors/Musou games do that. It's their gimmick.
You know the horde battle at the end of Skyward Sword? It's pretty much that: The Game.
But the game does have a lot more to it than that.
It has a story mode that, if it were canon, would fit rather nicely after Twilight Princess but sometime just before Skyward Sword.
Each character has his or her own play style and varying difficulty based on the character chosen and what weapon you use for that character, and what level and rank that weapon is, along with what stats you have equipped to that weapon.
Each character can also be upgraded through a skill tree at the Smithy so long as you have the right materials.
The focus on dungeon exploration is definitely not this Zelda's strong point, because there are none, but you can still fight giant bosses like King Dodongo, Argorok and Gohma, as well as Manhandla and even The Imprisoned and collect upgrades, Boss Keys and Heart Pieces/Containers from treasure chests.
The game has an adventure mode which sets you on the map of the original Legend of Zelda and each square sets you a mission to allow you to unlock new weapons, new characters and new costumes.
Missions range from rescuing allies to defeating giant bosses in a time limit or clearing out a particular number of enemies in a certain time.
There are also 100 Gold Skulltulas to collect across the story mode and the adventure mode which allow the player to complete nice portraits and acquire different tunics for Link, though the Adventure Mode is where the game shines as you get to see your characters grow and become stronger, being able to go from wiping out 300 enemies in 10 minutes to 1000 enemies in the same time.
Repetition can slow this game down for a lot of people though, I will admit that as it is purely a battling game with no dungeon crawling. And while it is amazing to see Ocarina of Time's Lake Hylia and Death Mountain rendered in full HD, or to be able to slaughter thousands of enemies as Ganondorf himself, I understand why that wears a little thin for some.
But if you're willing to uncover everything this game has to offer, then there and hundreds and hundreds of hours worth of play in here and everything I've described is available from the get go before even considering DLC.
The base game is complete as it is. It's polished and ready to go.
The DLC adds new characters for you to play as like Young Link with the ability to become Fierce Deity, or Twili Midna using the Mirror of Twilight.
Three DLC packs are themed to a particular game, and come with a new character or two to play with, new costumes, new weapons to unlock, and brand new Adventure Mode maps with new challenges and rules.
The most recent allows you to play as Ganon himself in a mode called Ganon's Fury and take on multiple giant bosses in a Boss Rush Challenge Mode
If you're cautious, I would suggest maybe watching some reviews or gameplay on YouTube, and then maybe renting the title first. If you then think it's a game you'll put plenty of hours into, then by all means, pick it up. You'll definitely get your money's worth.