Besides Barret's stereotypical ebonics talking (which is more due to the notorious translation) there wasn't anything that was really offensive. Yeah Cid yelled at Shera but it's no different than a typical boss yelling at his incompetent subordinate regardless of gender, he never actually abused her or anything like that, and there are far worse examples in countless other games that go unchecked.