Americans’ love of SUVs has set off a weird aspirational gigantism—and the redesigned Chevy Tahoe is a glaring example. But, says Dan Neil, unless you’re transporting a soccer team, steer clear.