> A Lorentizian manifold looks locally hyperbolic, so we need to imagine a light cone. Now the curvature of this manifold tells us how we need to distort light cones at different points to build up the full space.
A Lorentzian manifold is not necessarily locally hyperbolic and certainly the existence of light-cones do not follow from its hyperbolic nature. A Lorentzian manifold may be flat or curved, if it's flat we usually call it also a Minkowski space. Curved spaces come in many shapes of forms depending on the curvature which is a complicated geometric object. One particular case of curved space is a hyperbolic space which is one with constant negative curvature. A hyperbolic (constant negative curvature) Lorentzian (space+time) manifold is also called an Anti-de Sitter (AdS) space and plays a very important role in physics (see AdS/CFT correspondence).
> How the fuck do I visualize this? Is there some way to embed this in low dimension to play with it? For example, to understand regular curvature, you can play around with a sphere and a cone to get a feel for curvature ~= angle deficit ~= loopy deficit ~= holonomy.
Well, we humans suck at visualizing dimensions greater than 3 and projecting higher dimensional spaces into lower dimensional spaces (like we usually do representing a hypercube) is very hard to grasp unless you already know what you should be seeing. So your best bet is to choose problems with high degree of symmetry and visualizing only the interesting dimensions. For example, a stationary (i.e. doesn't change with time -> 1 dimension less to visualize) and spherical solution (2 more symmetries -> 2 dimensions less to visualize) can be easily visualized, in fact only has one interesting dimension! This solution is usually called Schwarzschild's solution. And because it has so high degree of symmetry it can be embedded a low dimensional space we can see, we usually call that Flamm's paraboloid and you can find a pretty picture here: https://en.wikipedia.org/wiki/Schwarzschild_metric#Flamm.27s...
> I don't know how to visualize the curvature of space-time, and I'm completely unconvinced I actually understand it beyond squiggles on paper. I'd love a way to embed and visualize this. Please tell me if you know how!
Unless you develop the ability the visualize higher dimensional spaces your best bet is to select highly symmetrical problems and visualize the interesting dimensions of those, the way we generalize to higher dimensions is through math not through the visual cortex. The brain is a highly plastic structure so maybe with training you could develop the ability to work visually with higher dimensional spaces but I also wouldn't be surprised if the visual cortex has been evolved and finely tuned to work with the macroscopic dimensions it had available and this exercise would turn out to be futile. After all, the ability to generalize to arbitrary high dimensions may have some cost and animals would have benefited very little from it.