Hi Cybergranny and welcome.
You'll still be able to curl up on your husbands chest at night - especially if you go with a nasal pillows mask. I use the ResMed Swift FX for Her (and have been using it for 6 years now). I dab a little AYR nasal saline gel into each nostril before bedtime to help with the air seal and to provide comfort plus protection against sores. I gather my hair up over the backstrap of my mask to help anchor my mask in place at night. Even if you are a life-long mouth breather, as I was, you can still use the nasal pillows masks. There is a simple brain retrain technique you can use to end your mouth breathing forever. We'll help you.
A SnuggleHose is a plush hose covering that you can purchase online. It comes in different colors. I have a pink one that matches my mask and like to think of it as an extra "teddy bear" in bed with me.. When you sleep, just remember to turn your exhaust away from your husband's face. You won't have to turn your face away from him. You'll still be able to cuddle. He'll appreciate that. He'll like the feel of the SnuggleHose against his chest.
CPAP is the most effective and, actually the least invasive of all the treatments offered for obstructive sleep apnea. It is the gold standard of treatment for OSA. Some people adapt to CPAP from the first night, but for most of us, there is an adjustment period of anywhere from a few days up to 6 months. Patience and persistence shortens the adjustment time. This is, after all, a whole new way of sleeping. Our brains do not like change. They crave whatever is the accustomed norm. Our job, as CPAPpers, is to provide repeated stimulus to convince our brains that this is the new normal. It's as simple as masking up each night and turning on our machines and relaxing into sleep...over and over again. I did my adjustment all at once and just kept my machine and mask on all night from the get go. I loved not having to get up and use the restroom at night anymore. I had been rising 6 times per night before I got my CPAP. My adjustment period was about 3 weeks. I'm a granny, too, by the way. You can do this. Everything is going to be even better than OK.
CPAP treatment has really changed for the better over the years. Machines are much quieter, masks are much better and more comfortable and there are many more comfort measures available to you than there were years ago - even just 6 years ago, when I began using CPAP. My husband was given a ResMed AirSense 10 AutoSet . He loves it. This machine is whisper quiet. If you snore, you will no longer snore audibly with your CPAP treatment and your husband will like that too. I also wear a night time dental appliance for TMJ syndrome as you do for your bruxism. This has improved my apnea (down to 25 apneas per hour on average), but that is still not acceptable for someone who wants to avoid the many serious, chronic health conditions that go along with untreated sleep apnea.
I was scared at first, too, but I made up my mind from the get go that I couldn't afford to fail at CPAP. There are just too many ill effects on our health when we are not treated for our OSA or are inadequately treated. My husband discovered, in the newfound quiet of our bedroom, that his own snoring was waking him up. He gathered the courage to get a sleep test done and sure enough, his sleep apnea was far worse than mine. His oxygen desaturations were down to 80% each time he had an apnea and his heart was racing to 175 beats per minute. We are "duelies" in CPAPdom.
You're going to be just fine. Keep on checking in.