No, it is not necessary for users to opt in under AppTrackingTransparency for SKAdNetwork. This is addressed in Apple's FAQ:Apple's framework for measuring the success of ad campaigns while preserving user privacy.