Not really. He hasn't failed a test so he can't be found guilty. Plus holding 2 bags of green doesn't mean he is smoking it and the drip could be anything too. Could be vitamins for all we know.
Looks bad no doubt, but unless anything else comes out it'll be brushed under the carpet, along with Fury's past.