I'm in such a relationship. Yes, they can be successful, if they both accept their limitations and differences, and give each other space when needed. They both need to accept that their partner's needs will be different, and work around that. Both partners will need to accept compromise. Stereotyped models or expectations of marriage may not work, so an NT partner should not try to impose these expectations on the ASD partner, especially gender roles within a relationship - it probably won't work and will cause misunderstandings and tension, and this is often a reason why such marriages fail. A diagnosis helps a lot to bring understanding to a relationship, and acceptance of each other's differences.
The partners should also set out goals, their individual needs and discuss what they want to gain from the relationship before the committment is made towards marriage: whether they want children, living arrangements, alone and together time, etc. It doesn't have to go quite as far as Sheldon's relationship agreement, but these things need to be discussed from the outset.
My relationship is not a typical realtionship, but it works because my partner accepted my diagnosis and stopped trying to change me or make demands on me, and I stopped trying to change him. We live together, but with separate bedrooms, separate lives, each with their own interests and schedule, but we always do something together on Sunday. We rarely eat together and we each cook separately, but once a month we clean the house together. If he's ill, I bring him food, hot drinks and medicine, and he does the same for me. We don't have kids, we agreed on that. Not all NT males would accept this situation, but he does. I'm lucky, I guess
