well it doesn’t look real time so i wouldn’t be able to tell you how it was done. i think you can re create something similar though. first I would move this thread out of resources and knowledge though and move it into wip & critique if you are looking for feedback.
next i would start breaking down elements of whats going on and see how you could accomplish each one of them individually. you said you already have an earth material? have you thought about adding a dissolve to it? maybe spawning some fx on top of it? do you want a realistic fluid sim flipbook? or would some smoke fx with rotation work? could you shrink everything down or do you want to try doing something fancier like this wormhole effect deepspacebanana created and shared?
also please share what you have so far!