Wanting to create a vacuum that sucks you out of hole into space

Overall the general premise is to move the actor/player toward a point in space over time.

Timeline + Set Actor location and rotation.

Search for Vortex Physics.