No, the message will remain in the overview of the module Messages. Only the details of the mailing will be deleted.
Did you choose the option Archive when scheduling the message? You will then have to go to the archive of the module Messages to find your message.