Cynical me would say it was used a lot at first, but then ASCII became something of the past, and some company doing data work started using commas, it got trendy and ASCII RS went into the closet.

Wikipedia suggest CSV was already around at the time of punched cards, I guess people would prefer commas over some obscure RS code.