team_name = this.file.name is an ‘absolute’ declaration. You have an list/array in your field team_name. So, you need to choose one. For that you need to use de function contains(field, "value"):
WHERE contains(team_name, this.file.name)
or
WHERE contains(team_name, "FOO")
If you add the condition team_name = this.file.name or contains(team_name, this.file.name), then this.file.name refers to the filename of the note where you put your dataview query! team_name = this.file.name means “give me the list of the notes/files where the field team_name have the value (exact value) equal to the title of the note where I put this query, i.e, this note”.