Even in the scenario where shedding by means of contact, sweat, etc. isn't a thing, I would absolutely not have sex with anyone who has had the vaccine.

I would think that would be the one way it could be transmitted from person to person for sure.

It is entirely up to you, but I personally would not take that chance until we know more.