On this SRAM Apex 1 derailleur, what does this barrel adjuster do?
What happens if I turn it clockwise/anti-clockwise?
It lengthens or shortens the housing length to adjust the lateral position of the derailleur cage. It's used to adjust derailleur 'indexing' so that the chain sits properly on the cassette sprockets.
Mountain bike shifter units have barrel adjusters, road bikes use this one as well as having frame mounted or 'in-line' adjusters some where on the housing run.
This video from park Tool Company has a good visualization of how it works: