I am married and was a CPAP user for a 5 month period (now I use a dental appliance). During my use of CPAP, my wife was very supportive. However, when I went to a sleep apnea support group meeting there were several single people who were clearly having concerns about how the CPAP machine would be viewed by a bed partner.
For example, the hostess of our support group meeting had requested that we bring our bed partners to the meeting. She asked each person in the meeting to comment on their CPAP experience (either as a user or bed partner). One single woman made the comment, "I don't have a bed partner and I don't think I will be able to get one as long as I am on CPAP."
I had an experience with one of my sons that bothered me. We were traveling and it was the first time he had slept in the room with me and had seen me using the CPAP machine. He woke during the night, saw the machine hooked up to my face, and tried to pull it off of me! He thought some creature was attacking me (kind of like in "Alien", I guess). Later he asked me if wearing this machine at night meant I was going to die soon. I reassured him, but it was still hard.
I believe that people need to understand that a family is being treated for sleep apnea, not just a single patient.
By the way, since I use a dental appliance now instead of CPAP, my wife says she misses the "whirr" sound! I may need to pick up one of those white noise or sea-surf sound generators.