So, this appears to be a limitation of Facebook. Here are the API docs from Facebook which have no mention of how long the image URL returned if you pass redirect=0 is good for.
Looks like some Auth0 users also encountered this.
So I think you are on the right path with downloading the user's Facebook images and updating them on your side every time a user logs in.