Does Do Not Disturb mode turn off automatically?
No, just flipping it on in Control Center won't get it to automatically turn off.

To get Do Not Disturb to automatically turn off, you need to schedule it to do so in Settings > Do Not Disturb > Scheduled.