As long as you're subscribed to a Substack and have push notifications enabled, you'll receive an app notification about any new posts.
To completely turn off notifications (which means you'll no longer be subscribed to the publication), head to your Substack Account and click on the publication in the Subscriptions section.
In the Notifications section, click "Unsubscribe".
Note: Turning off all notifications will unsubscribe you from the publication but will not cancel your subscription if you're a paying subscriber. Learn more here on how to cancel your subscription.