Is it possible to override MageMail's product url fetching?

Yes, you can use the `kj_magemail_product_image_fetch_after` observer to fetch the image URL and modify it.

Here's a quick example of the observer setup in `config.xml`:

And the observer: