That is what it is meant to do. If you'd like the emails to be sent to an email from your spreadsheet you could dynamically send them so if you're emails are in column C you could say:

MailApp.sendEmail(row[2], subject, message);

I would definitely test this out first by putting your email in column C and seeing if it sends you a reminder as I haven't tried this out myself.