Elfish was having a wonderful psychedelic dream full of gummies. But sweet dreams doesn't mean "dream of sweets". It is an idiom telling someone that they should have good dreams at night and not nightmares. More broadly, the term can mean "sleep well."