Update memory barrier documentation (WOCommon, dfbe816)

Replace existing Doxygen comments with much clearer, more rigorous explanation of memory barriers and how they work, along with an example demonstrating the double-checked locking pattern for singletons.

Signed-off-by: Greg Hurrell <greg@hurrell.net>