Is a hognose a good first snake?

My son has been begging for a snake for Christmas. I think he’s finally old enough and could reasonably be responsible for it, so we are getting him one. We went to some local reptile stores just to see what they have and he fell in love with a tricolor hognose. I can’t blame him, it was adorable and very sweet. We came home and did some research, and some people said that a hognose is not a good first snake because they are mildly venomous and are picky eaters. Initially I liked that they are smaller than ball pythons and require smaller tanks, and I think they are just the cutest little noodles. My husband is not excited about a hognose after doing research. Thoughts? Is it a good first pet snake?