So, I want to source the Customer's email (standard field) from customer form to a new custom field on Sales Order transaction form, but email is not listed as a choice in the sourcing dropdown. Do I have to use a workflow to populate it? It seems backwards to me. Not sure why it would not work.

try free-text

nope, still doesn't show it. I can see every custom field from custom record except email