One child (age 3), midsize dog. A hatchback is perfect. Without the dog, a sedan would be fine too, though I have always preferred hatchbacks or wagons because they have better visibility and more storage.
Kids tend to accumulate stuff around them. If you get a big car, you will accumulate stuff to fill it. If you don’t, you won’t. I’m with your husband here. SUVs are not necessary.