I don't think hangover horniness is primarily a physiological phenomenon. It's rather caused, I would guess, by the (sad) fact that very often getting drunk means embassaring yourself and/or failing to get laid. On the next day, when you're in a state of mental reduction and disillusionment...