It is replaced with Black-Briar mead after completing "Dampened Spirits".
Over 300 bottles of Honningbrew Mead can be stolen from the meadery before the quest Dampened Spirits. It is still possible to find Honningbrew Mead in one of the barrels in Honningbrew Meadery after completing Dampened Spirits, varying from 1 to 4 bottles, though these will have to be stolen. Several more bottles can be found in a barrel, with one more beside it, in the passageway under the meadery and can be taken without stealing. Several bottles can also be found in several homes throughout Whiterun and the kitchen of Castle Dour, Emperor's Tower in Solitude, 2 bottles can also be found in Lund's Hut. On rare occasions, a bottle can be looted from a bandit.