Cross apply is sort of like an inner join (but it really is not - in the example you posted you could not have used inner join). Cross apply allows you to use the rows from the left table in the query within cross apply. In that sense, it can be thought of as evaluating the right virtual table for each row in the left table.
It would be very useful to watch this video and/or read through this article, both by Ben-Gan.