You can actually make this work if you don’t use the email address column type, it will need to be either single line or multi line text with the emails separated by commas.
If you are using the email column type it only recognizes one email address....