Absolutely possible, and yes I do know a family like this. I’m inferring that you’re planning a move from NYC to a suburb of NYC…if that is the case then most likely there are at least some public transportation options that can get you into the city for work. Most major city suburbs it’s generally not too hard to get downtown. Where things get dicier is distances in the suburbs will be a lot greater than you are used to. Your corner market might actually be 2.5-3.0 miles away or even further, and while almost every major city I’ve ever been aware of you have some public transit options reasonably close that can get you downtown, there isn’t as much uniformity in availability of transport for “local” travel within the burb you live in. So you may experience the maddening situation where you can easily get downtown via bus or something, but have no way to independently get to various relatively close to your house stores without walking a fairly great distance or being driven by your fiance.
Anyway, to the family I knew like this. My great-grandparents lived in one of the earliest sort of suburban communities when suburbs first started to come into existence. My great-grandfather had been able to drive since the early 1900s but he was in a very unique position of having driven for work back when cars first started becoming part of society (most other people from that generation in my family did not have a car until much later, when they became more generally affordable.)
So pretty much for their entire life, great grandpa could drive, great grandma couldn’t. She was fine with it up until about the age of 81. My great grandfather, like many men on that side of the family had a short temper, and they got into an argument in the car and he pulled over to the side of the road and left her there as he stormed off down the road on foot. She basically was stranded because she had no idea how to operate a car, an hour later he came back and they made up, but she also started taking driving lessons a week later and had her driver’s license at age 81 for the first time (she drove until she was 94.)
All suburbs or different, but at least in the suburbia I’ve been familiar with you can have a family just like my great-grandparents did where only one person knows how to drive. However, the person who doesn’t know how to drive needs to be comfortable with the fact that a lot of things a driver can do independently they will have great difficulty being able to do. That’s probably one of the biggest adjustments you’ll have versus city life, depending on what suburb you move to you may literally not even be able to get a candy bar without a 2+ mile walk, and even if you only buy a day of groceries at a time a 2-4 mile one way walk to carry a day’s worth of food is brutal. So anytime you want to buy something you will need your fiance around, so you had better be comfortable with that. Thinking long term, recognize even if you and your fiance have compatible schedules for that sort of thing now, it could easily turn out years down the road you have very different schedules (unless you can predict with absolute certainty what your respective lives will be like 5, 10 years from now) and you might be “stranded” at home for hours at a time waiting for him to get off work or something just so you can go get your hair cut, go buy groceries etc.
Anytime you need to go to a doctor’s appointment he’ll have to take off work too in order to drive you there, even for minor stuff like dental work and annual exams.
In NYC a car really isn’t a necessity, but in some suburbs life can be very annoying and inconvenient for some people if they can’t drive. It’s impossible to know if you’re the kind of person who would be bothered with basically being 100% dependent on another person to get around.