Ok, I guess I may have figured this out myself. From the reference manual section 27.5.15, FlexSPI always supports XIP regardless of flash device if placed in Advanced High Performance Bus (AHB) access mode. In addition, u-boot subsequently copies itself into external RAM (0x80000000) area for better execution performance.