Add substrait support for multiple files in `ReadType::LocalFiles`

[alamb]

Is your feature request related to a problem or challenge?

@Lordworms added intiial support for ReadType::LocalFiles in #10842 but it does not yet support multiple files. See the TODO https://github.com/apache/datafusion/pull/10842/files#r1633410593

Describe the solution you'd like

No response

Describe alternatives you've considered

No response

Additional context

No response

[tokoko]

I'm thinking of taking this next. From a cursory look at the options available, rewriting the implementation to use ListingTables looks most appropriate to me, does that sound right?