I realize this book is fiction, but the author is a retired O-6, who's son was a Navy-turned-USCG helo pilot so my point may be based in fact.
In it, the author wrote that sailors could be kicked off a ship for drugs, but the command had to gap the billet. So, you could get rid of them, but...