The consequences of getting in any kind of trouble where alcohol was a factor is career-ending. Paying for a prostitute has now been relabeled "sex trafficking" and is specifically prohibited under the UCMJ. You could be court-martialed and sent to prison over it.
Unfortunately you are right. In my ex’s unit a Marine, who did not normally drink, got drunk on a Thursday night and puked in his shit can. Friday morning barracks inspection was a career ender for him. He suddenly was labeled as having a drinking problem.