It did introduce ambiguity though. Without the comma it is 100% clear that sentence lists 3 people.

Practically that would be very likely to be the case to the reader, but grammatically no, it's still ambiguous.

> They went to Oregon with Betty, a maid and a cook.

Betty could be both a maid and a cook. So there is still ambiguity.