Tolerance to different effects is developed at different rates; not necessarily grouped into "cognitive" and physiological". Tolerance development has several mechanisms; even just in terms of changes within the brain (changes in receptor density, receptor desensitization, others).

https://en.wikipedia.org/wiki/Drug_tolerance#Pharmacodynamic_tolerance

Alcohol has many different affinities. It modulates the GABA system, affects NMDA, AMPA, nitotinic acetylcholine... These different mechanisms correspond to different aspects of alcohol's effects; both cognitive and physiological. These systems adapt to constant alcohol use at different rates, so their corresponding effects will develop tolerance at different rates.

https://en.wikipedia.org/wiki/Alcohol_(drug)#Pharmacology#Pharmacology)

Even drugs with relatively simple mechanisms produce tolerance to different effects at different rates. Tolerance to analgesia and euphoria from opioids develops fairly quickly, whereas tolerance to constipation and pupil constriction may not occur at all.

https://en.wikipedia.org/wiki/Opioid#Reinforcement_disorders