It means that it produces sleep or drowsiness, making sleep. Sleeping pills, narcotic, hypnotic, sedative. It also means tedious, boring, dull, disappointing.
SOPORIFIC: THAT IT INCITES, INDUCES, OR PUSHED TO THE DREAM.