The difference can be summed up with this Convenience vs Security.

Going deeper you can consider mobile and desktop wallets a combination of the 2. We created a "Cryptopedia" that compares and contrasts all the different wallet types including popular examples of each type.

https://midcrypto.com/pages/cryptopedia