I'm well advanced on my first "twisted" map, and I must say it's a lot of fun. It may be helpful to remember how map projections are made - people are used to cylindrical projections where the map surface is a cylinder wrapped round the globe, usually tangent at the equator (though you get a very fun map if the tangent is to the Greenwich meridian). In the twisted axis map you are looking at a plane map tangent at the North Pole, so the South Pole is exploded to infinity. Sailing off the map is impossible, and true circumnavigation should actually be making a circuit of the pole. It would be better if the map were square, but Civ 6 doesn't seem to permit that.
Note that compass directions are different; the edges of the map are not N, S, E, W; they are ALL south. If you start a unit halfway between the centre and the right map edge and move towards the top of the map, it is not moving north, it is moving east.
It is a bit like the continents map in that you have two large land masses either side of the central ice, but these are not the only significant land. I find I am sharing one continent with Brazil; Hungary is not far away on its own smaller continent, and the other five are together on the other large continent. In most maps, you hardly bother exploring the top and bottom map edges because you know in advance they are probably not worth settling; here you can find useful land at all the edges except in the corners, as Victoria showed.
I haven't got far enough to see if the central ice melts!
Incidentally, there would no reason not to base a map script on a cylindrical projection tangent to the Greenwich meridian; then you would have both the Arctic and Antarctic ice masses lying along the "equator". That would be a true "twisted axis" - what Firaxis have made is actually just a polar projection.