DirectX loads all images in the format that is used by the 3D hardware. So there is no fixed rule which format you get. It depends on your hardware.

I don't think that there is a 3D card that would support the 888 format, so a 24 bit image is most likely loaded in 8888 format, even when the image contains no alpha channel.