You can opt-out of the TTN Social email Newsletter by unticking the checkbox next to the option for "Receive the periodic TTN Social community Newsletter" on the https://social.ttn.place/setting/email-setting page under your profile.

Click on your Avatar image > Privacy Settings > Notification Settings > Email Notifications (this is a tab on the Notification Settings page)