SACD is physically a (multi layered) DVD disk.
If single layer, it contains the music in DSD format. This can be in stereo OR multi channel (where multi channel can be any where from 1.0, i.e. true mono, to 5.1).
If multi layer, it contains a CD layer (so the disk can be played on any CD player), as well as a stereo and/or multi-channel SACD layer (which is encoded in DSD.)
So, yes, SACD is the disk version of DSD.
As for Brothers In Arms, I refuse to buy MoFi as they are well overpriced, and if I want stereo I would rather go to the better value stereo vinyl, and for me, a lot of SACD magic comes from multi channel recordings. See the list I made previously.
Get Linn sampler SACDs from their website for a fiver each if you want to hear and compare SADC and CD, as they are multi layered and exceptionally recorded.