Some were, some were for specific samplers. There was a chunky mini disc type format for an Emu (or Akai!) extension drive. SF2 is a pretty established format for samples.
I have a shelf of sample CD's. Sometimes I play lucky dip with the CD player and sampler.
I always assumed these were just audio CDs that you had to sample manually lol