I'm not sure if Petipa created them, or why the child Aurore's name was given to what, in Perault's version, was her Mother, the Aurora we know from the ballet, but 'Desire' [apologies for the lack of accents, the codes don't work on my laptop] is a reference to Louis XIV, as it is said his Father, Louis XIII desperately needed an heir to keep his unstable brother off the throne, so when Louis XIV was finally born, he was known as 'the desired one' for this reason and also for his personality in later life.
There are many references to Louis XIV's court in The Sleeping Beauty, such as the choreography, as the court is set out based on rank and ceremony, as in the days of Louis XIV, and Carabosse's courtesans mock this etiquette in the Prologue, leaping around and removing Cattalabutte's wig, whic many, if not all coutesans, would have worn at this time.
I cannot find an origin of 'Carabosse' but I did come across another mythic story, with a similar plot to the tempest, which involves an evil character called Carabosse, so I suppose it has been associated with evil for a long time.