My last and first cruise were on the Carnival Holiday about 7 years ago. The wife and I are going on RCI Sovereign of the Seas for a 4 day Bahama cruise in Aug.
From my limited experience on Carnival, your husband will look fine and probably better than most guys. Nothing wrong with a a good quality light suit anyway...Seems just right for a Summer type cruise to me. Have fun!