My wife and I have location sharing enabled in case something happens to one of us. We usually don't use it, but its good to have when we need to meet up at an unfamiliar place after something goes sideways for one of us.
But if your SO doesn't trust you enough to allow you private moments and would accuse you of cheating, your relationship isn't based on trust and thus is very weak.
How I explain Self-Hosting to the non-techies in my life: "This is me practicing my trade. As a server and systems admin, I need servers and systems under my control that I can experiment with, set up, configure, break, and fix, and self-hosting has a benefit that instead of four computers, two by my wife and two by me, each hosting its own data, I can set up a network storage device where both of us can store our data." Any more than that, and I probably won't go into detail, because I don't ask my accountant friends to go into the weeds about their career and return that favour by not going into the weeds about my own. :)