I feel like you're way overthinking that scene. There were a few hint that Gaius wanted to hook up with Starbuck before that scene in the episodes preceding (if I recall) - remember, the fleet at this point think he's weird and charming. They don't know his backstory.
Then they hook up and that's it. It's over. They never hook up again. The purpose really wasn't meant to shock the audience at all.