Method that deletes this category from the library. Any assets associated with the category will also be deleted.