Does Do Not Disturb mode turn off automatically? If I turn on Do not disturb mode from control center, will it automatically turn off in the morning?
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.