Holographic perspectives on chiral transport