Hi there
I think intimacy is still possible with a stoma.
My husband got his when he was 32, 2 years after we were married. I think we pretty much continued as always in that department. I loved him so much that I could not really imagine life without him and the colostomy was a small price to pay in exchange for his life. He is a very positive person, so he does not dwell on it very much. Obviously, there is all the usual ugly crap that goes with having one and it's not easy to get used to, but he never convinced himself that he was no longer sexually attractive. That made things a lot easier for me. The truth is I never even see it or think of it when I look at him, the colostomy has nothing to do with the person he is and has no bearing on the way I see him.
-That being said, I do have to add that it is best to shower right before sex. Like, the other person can really smell it if their nose is right up against it. He forgets sometimes and still acts like that issue isn't there, but I have to tell him it stinks and he needs to shower. At first, it would really upset him, but we are at a point where he just takes the tip and does what he needs to do.
-Also, oral if there is something in the bag is a little bit gross. Honestly, I am not crazy about that whole thing and I guess he knows that because he does not press me to do it. However, after a shower and a fresh bag, it's perfectly fine.
I know it's different when you just meet a person for the first time and have to tell them about the colostomy, but I still think it can turn out well with the right person.
If it's just casual sex, then I am sure you can conceal it to some extent.
If it's a relationship, I would wait a while before telling the person, like wait until they are completely into you and then explain. Honestly, it's really not disgusting or disturbing at all once a person gets used to it. We barely even think about it anymore. To us, it's just a matter of fact part of life and we share it like any other mundane thing.
The bag even burst all over me one day when we were having sex. Once again, not grossed out, just showered and moved on. I think the right person would understand.
I hope this helps even a little.