Case 1: An ordinary hide is effectively tanned and fashioned into a waterskin; under the core Hanafi ruling it may hold clean water for wudu.
Case 2: Dog hide is effectively tanned; the Hanafi and Shafi‘i rulings differ on its purity.
Case 3: Pig skin is tanned; the explicit exception means it does not become pure. Human skin also has a separate prohibition grounded in dignity.