Isn't the Unix join essentially doing an inner join? Why is the original SQL doing a left join while the text processing with Unix join is doing an inner join?

Yes, the left join will scan the whole table. Left join means to return all the rows from the left hand side table. It won't use the index.

Inner join with index is way faster than left join.