Listening to other parents and from what I have read here and on other sites and my Friends with SN children this seems to be the way it is....
The majority of the Mums (inc myself) are with their SN child all day, you see them a toddler groups with other children, at School or the park etc.
We tend to be a bit more negative than our DH, I think because we see our SN Childs capability's and incapability's more.
DH/DP come in after work, have a play with their child and maybe don't see the disabilities as much. They don't see their child with others day in and day out.
This is not everyone of course!! Before anyone corrects me lol. I just think in general that's how it is.
So you are not wrong in your thinking.
I can turn round and say "well Ellie is unlikely to have a Boyfriend, get married or have Children" My DH hates me saying anything like that. As does my Dad.
Now my Mum will think a little more like me.
Just think we are a bit more realistic!
I read up a lot on the internet, he doesn't to know anything.. It doesn't mean he doesn't care, he loves both our Daughters v v much. He just doesn't want to know any of the not so nice things
Don't know if that makes it any sense at all, sorry for waffling!! just trying to say, no there is nothing wrong with feeling like this, I do, my Friend does, so we can't all be wrong!!!