I have never heard of cargo cadets being offered choice of "transferring" to main fleet.
But i have heard of some who "requested" for Cargo at their partner's request.
My take on this to threadstarter, if your hubby is going to sleep with other women, he'll do so anywhere and with anybody..