Hello Cheeky Monkey,
Welcome
I agree with all that Gentle John has said in the above reply.
Also, I would add that no matter how intimate one becomes and how love grows - if the non-stoma person in the relationship finds they have difficulty in accepting the stoma - despite their best efforts, it may be that they are unable to change their reservations. Some folk just find a 'difference' a challenge to accept unconditionally, and in all other respects, they may be an okay person.
An illustration of this can also be understood with other 'changes' some folk find difficult. [For it's not just stomas either.] When I had my metal framework bolted through my leg during the process of having a fixed ankle joint, I found that a couple of really good friends actually found the concept of the bolts going through my flesh into my bone really difficult. They felt for me, and despite this, they felt really uneasy looking. So much so, I always wore loose sports trouser bottoms to cover the leg/frame when meeting. So although this was better for them, they still remained extremely uncomfortable with the concept. Although they felt that it 'shouldn't affect them as it did' [and, bless them, were embarrassed about how they felt too]. Needless to say, both of these friends have remained friends, and our friendship in other respects has not changed. [Although I do privately think and hope that if ever my friends or their respective partners ever had similar bodily changes with radical surgeries themselves, how well would they accept/cope!]
These things are never known for sure until they are actually experienced for real, but to have shared others' experiences ahead of time can be helpful so that one is not hurt in the event a relationship is not fitting for those of us who do have stomas.
Guess I am trying to convey the point that with some folks, it's not just a matter of time that is required for adjustment. And, as Gentle John and others will concur, especially with intimacy, our situation either is totally accepted, or it will become apparent there is a resistance. And where there is a resistance, no matter how subtle, chances are difficulties will remain.
All of the above having been said, there are some very small cap-type non-drainable consumables [Dansac, and probably other manufacturers have them in their product ranges] that one can use as a temporary replacement for your regular collecting pouch system when an intimate session is expected or planned. These little round ultra-mini bags are snug to the stoma with no hang-down and are very good, giving one near total freedom [as far as one can achieve whilst wearing something over the stoma]. Obviously, if one can time intimacy to fit in with a low output period [and it is doable for some of us, even with an ileostomy, once one gets to know your own system and what foods react in what way and likely throughput times]. And for those with a colostomy, there is the irrigation option allowing for more control of output for a 'freedom' time window.
Over time, we get to know the doables and the 'possibles' and definitely the no-nos.
Big smile.
Hope this helps.
Good luck
Best wishes
~ ~ ~ ~ ~waves ~ ~ ~ ~ ~
Jayne