App Engagement Campaigns that are present in the Google Analytics Interface are not present in BigQuery.
All other campaign data gets transferred to BigQuery.
Is there a specific reason for this behavior in the transfer job?
The transfer job only uses the Google Adwords v201809 version of the API.
App Engagement Campaigns were only added in the newer Google Ads API.
You will need to set up a connection the the new API in order to pull in that type of campaign (as well as a host of other ad types).