Sleeping Beauty Aroused (1989)

"And only a kiss on the lips could awaken the princess from her deep, deep sleep."

Hyapatia Lee is the princess. Tori Welles is Marvella, the witch. Tami White is the good fairy. April West is Mother Goose. Princess Amber and the rest of the royal court fall into a deep sleep for one hundred years until she is awakened by a kiss (and a lot more besides) from a passing prince.