I'm surprised that AWK is so bad at handling CSV out of the box.

Yes, I know about the --csv flag in later versions of gawk, but that isn't an option in this case.