Covid isn't sexually transmitted, but as it's transmitted through respiratory droplets, if someone has covid their sexual partner would be at risk, yes. If everyone involved is fully vaccinated and is practicing safe behaviors in their daily lives (masking, distancing, etc.) then the risk will be lower; it's really up to what individuals feel comfortable with.