In order for a liquid airlock to work, some points must be considered; they have been mentioned in some of the other answers, but I will try to combine them and suggest some new implementations.
Gravity:
As stated, there must be some gravity (or constant acceleration) present for this to work in principle. The required column height (see sketch in the question) of the pressure head is $h = p/(\rho \cdot g)$.
To compensate for a 1 atm habitat pressure on the Moon, a water column would need to be about 60 m high, and a mercury column 4.5 m. On Earth, 1 atm corresponds to only 760 mmHg (millimeters of mercury).
Vapour pressure of the liquid vs. pressure of the atmosphere (if any):
The rate of evaporation depends on the external pressure as well as the intrinsic vapour pressure of the liquid.
Liquid metals have low vapour pressures, which is why they were suggested in the original article. Water, on the other hand, has a much higher vapour pressure and will evaporate / freeze and sublimate very quickly in space or on a body without a significant atmosphere, e.g. the Moon.
There are some other possibilities for liquids from this stand point; silicone oils, for example, are used in vacuum applications because they can have low vapour pressure. Quite recently (compared to the article's publication date) room temperature ionic liquids have been studied which have very low vapour pressures and have also been used in vacuum applications, e.g. in this article.
In any case there will always be a small rate of evaporation on a body without any atmosphere, which means you should top up your air lock once in a while.
Practicalities of passing through the liquid airlock, buoyancy forces and reactivity of the liquid:
Liquid metals like Mercurymercury and Galliumgallium tend to be very reactive and will amalgamate (react)form solutions with most other metals. NaK is very corrosive as well. This could presumably be solved by coating exposed portions of cargo with inert polymers like PTFE. Silicone oils, on the other hand, are very inert and should pose no problem at all.
David Richerby mentioned that buoyancy can also be a problem, especially with the high density of metals. Buoyancy is proportional to gravitational acceleration (see xkcd's What If) but diving through roughly 5 m of mercury in your non-metallic space suit on the Moon would be next to impossible unless you had big Tungstentungsten or Platinumplatinum ankle weights).
So, to sum up, it would be pretty difficult to make as well as use a liquid airlock. The volumes and masses of the liquid alone would be way too great to carry even to the Moon. Maybe you could extract some of the resources in-situ, however, to me it seems this type of an airlock is totally impractical, unless you already have a well developed industry on another planet. Although, it is a nice physics and chemistry problem to think about.