There are some pretty great answers here in the forum. For me, it took for a family member talking to my wife with the exact same Ideas that I had to get my wife to give me the green light, but to keep her out of it. I cannot use our shared money, and she wanted nothing to do with it. Sucks right???! But after her listening to the podcasts as I drive, and hearing the conversations I have with fellow investors, she came to me and said "If you can find a multi-unit that fits these criteria (remarkable schools, big backyard, 4 bed, 2 baths...), I will be fine with house hacking". I found several places that fit the criteria, but then we were hit with the blow from doing a COVID deferment, and cannot purchase any property until making 3-consecutive payments out of deferment. So needless to say, as long as your spouse allows you to be you, and It doesn't affect how your family operates, they will eventually get on board if they see the value in it.
Yes, it can be tough when your spouse doesn't want to go along with your hair-brained schemes until someone else they trust brings them the same information. At the end of the day, when they realize you will make decisions that are best for the family, all will be well.