Did you try the appearance tab > try to fix option?
You don't have to support us, but if you read what you wrote it sure sounds awful, and is why I make it a point to say.
So you know, we have tools in powerpress and with hour hosting to seamlessly migrate media and update the media urls automatically, we want you as a customer and we have the tools in place to make it happen.