What is the difference between a local Mailbox and an archive in Apple Mail?
The 'Archive' folder that Apple Mail uses with IMAP accounts is still on the IMAP server.
In short, it's just a default folder to move email to, for people who like their Inbox empty.