What happens to the record when they turn 18?

The settings do not change on their own. At 18, the Creator can sign in, confirm control of the account and manage the record themselves.