OK, so...here's another thing: it's often said that (some) autistic folk are great in an emergency. You'd think that would be completely incompatible with the whole "deep and immovable needs" thing - like sensory issues etc.
It's actually not. These things can be deferred, to a certain extent; it's hard to explain, but speaking for myself...it's kind of like I can cut myself off from all of that, for a time, and focus exclusively on what's in front of me until the current urgent situation is resolved. Trouble is, there's a cost; that almost always results in a period of shutdown, although that can be avoided with a period of quiet time in a sensory-light environment.
So, that's what happens in an emergency - my other half knows that, and will generally let me deal with the immediate issue, and then give me time to recharge and recover by taking over afterwards.
Children are...a bit of an oddity. Not completely incompatible, but somewhat predictable even though they're a sensory nightmare (loud/smelly/dirty things :D ). We always handled them the same way as an emergency - I'd take care of the bigger anomalous stuff, and my partner would take most of the day-to-day stuff. Everything else would be planned ahead of time (even if it was just "If <this> happens, then <that> and we know it'll take <x hours> so we can prioritise and reschedule".
Our daughter's NT through-and-through - she's not biologically mine - but because she grew up with me, she has a lot of ND tendencies to the point where she can pass for NT or ND depending on the day. She always knew that I needed my own space, and that I was mostly crap at making up stories and play etc, but as parents we played to our strengths. So...I taught her gaming, technology and music, and built a strong love of sci-fi in her. She just learned to treat it as totally normal that she'd be able to pick the parent based on what she needed at the time.
I'm not sure if that helps, but in my eyes it's totally do-able; after all, we reproduce quite successfully, hence all the ND people in the world ;) We're not unable to adapt, we just have to adapt in different ways to you. The key is explicit communication, planning ahead and not making assumptions (or even challenging your assumptions) - or, more likely, being open to changing your mind on what "normal" represents, and maybe coming up with a new way to live life that neither of you have a template for.
It's worked for us, and after 25 years we're stronger than ever.