Question:

It means something like, 'elder woman', but when is it suitable to use it and when is it just plain rude?

Answer:

They do not want to be called "obaa-chan" because it means they are old. So better to avoid it as much as you can.