Are we just thinking up insane stuff to ask? Anyway about the only two people in a command who might and I mean might be able to call the CO on being drunk would be:
Possibly the XO...and that depends on the circumstances...but the rest of the command probably wouldn't find out.
Maybe second would be the Command Sergeant Major (Army) or Command Master Chief Petty Officer (Navy). I am betting on the senior enlisted getting away with it quicker than the XO...but even that is dangerous territory.
I don't think anyone else would try to argue with the CO. That would be too hard to prove. As far as ridiculous orders...well, plenty of sober CO's are quite capable of issuing those. I have seen many ridiculous orders from the CO and it made you wonder if he (she ) was sober or not....but you grin and bear it and say "Yes, Sir/Ma'am" and carry on.