Well - "worth" is always a tricky question, but...
The Haunted Mansion pins have been amongst some of the most wanted pins and could get quite a bit as far as trade value goes. That said - in the recent pin trading event, these pins were available again, making their status not quite as "coveted," but I still believe that they are quite wanted. Not everyone was successful in getting them during pin trading.
So - they are retired, but they were recently available during a special event only. Does that help at all? Hope so.