@PastaNuketown My DH and I are both undiagnosed, but believe we are on the spectrum. Our older DS is diagnosed autistic and our toddler DS is more NT than our older DS, but has some autistic traits (e.g. toe walking and hand flapping).
My experience as a mum has been 100% positive. I did not actually know my DS was autistic until he went into a structured group environment (a nursery) because he was fine at home. I now realise this is because our home environment is ASD-friendly and, also, I really understand him - because he is so similar to me. So, for example, he never had meltdowns at home.
If you have kids with your DH, you are likely to have children who are not entirely NT. However, (and this is a big HOWEVER) they will be exactly like you. They will remind you of you as a child. You will completely see yourself in them, understand what they are going through and, as such, you will be kickass parents. You will never take them to enormous, noisy crowded parties. You will buy them sunglasses, share their special interests, and share advice on social scripts. You will be WAYYY better than NT parents of an autistic kid could be.
You will, most likely, form a bubble of neurodiversity in which you and your family are a neuro-majority all of a sudden. You will become a massive advocate for your kids, and spend a lot of time feeling like it's the rest of the world who has a problem.
There are a couple of studies showing that people with ASD, who have ASD parents, are rarely seriously affected. Most of the children who have very major support needs are a result of 'de novo' (i.e. new) mutations that have serious co-morbid conditions (e.g. epilepsy or learning difficulties). It appears that ASD kids with ASD parents are ASD due to small mutations passing between parent and child - just like every other trait.
Hope that makes you feel better :)