I don't mind his character as a potty mouth and I was never bothered by it (or impressed for that matter), it was just how he was. Some people in real life use such terms like they're going out of fashion. However, now that you mention it, his anger is misplaced and unnecessary and in all honesty Shera doesn't deserve it at all.

So Cid's swearing, that's okay. His abuse to Shera, not okay.

I think the real issue is why Shera put up with his crap. She says she is in debt to him or something, for ruining his dream... but damn, he would have blown up if she didn't do anything. She cared that much for him she was willing to die. Cid should be alone, but she sticks around. I think the real issue is her mental state, but that's a psychology discussion that I would rather avoid as it touches on issues that women (and men) face in real life. Furthermore, I don't think there is such meaning to it in the game.

But the rocket scene is okay in my eyes, a little melodramatic, but okay within the realms of the story. Apart from the fact that it launched. It lifted off the ground, fire blazing, hovered, and then came crashing down and everyone, including Shera is a-okay. That's my main issue with the scene. I think she would be dead.