Thanks to Lex Friedman for pointing this out:
Head over to Settings, tap on Do Not Disturb, scroll down to the bottom, and set Silence to Always, instead of Only While iPhone Is Locked.
When your kid is finally asleep, the last thing you want is some stupid Instagram video to start playing.