Yes, a drunk person could pilot a drone into something, but it takes some effort. A drunk person could throw a rock at someone, but we don't ban drunks from carrying rocks.
This law would sound more compelling if there was a rash of drunken drone injuries.