What determines the products that show for that sort feature and how long are they considered “newest arrivals”?

If customer sorted the search results by “newest arrivals”, application will show him search results sorted by the field created_at of products. So products which were added last will be in the top of the search results.

There is no expiration time. List will change only if you add new products or disable old ones.