A character in a story happens to be a character, instead of carefully written to be non-offensive? Abusive, yes, but there's no indication he ever touched her.
And even if he did, there's nothing strange about that being in FF7. The game touched on alot of mature concepts and events. And most importantly, no, Cid was not meant to be "likable" in the same sense as the other characters. His mouth was worse than Barrett's and he chain smoked.
Like everyone else in the story, Cid was a good representation of how Shinra manages to fuck everyone over. He was an ambitious man who had his dreams ripped from under him too many times, and his attitude is the result of that.
The fact that Cid is offensive, scruffy, and abusive is a part of his character. Removing that from him shallows his backstory and completely defeats the purpose of having him be a party member in the fist place. What happened between him, Sheila, and Shinra is just as important to the narrative as what happened between Cloud, Tifa, and Sephiroth.