Change public URL for user photos
Never too late to answer your own question.

This is easily resolved now as Craft 3 stores user photos as assets, you just need to assign the CDN URL to the public URL field in Assets.

https://docs.craftcms.com/v3/changes-in-craft-3.html#user-photos