Is ATT opt-in required for SKAdNetwork?

No, it is not necessary for users to opt in under AppTrackingTransparency for SKAdNetwork. This is addressed in Apple's FAQ:

902