Yes, there are definitely some specific crimes that can’t be prosecuted if you’re too intoxicated to form the requisite intent. It’s called the “intoxication defense” and it applies only to crimes requiring what’s known as “specific intent” to do something.