You know when your female friends with kids turn to you and say things like "I love my son with all my heart but I wish he was never born"? 

That's what "not sure" means, it's just that men tend to be blunt about it while women tend to dress up their indecision with excitement