Mike and his wife prepare to be intimate on the floor, but are interrupted by a phone call.
Zach creepily lusts after Laurel, and walks in the wardrobe room while she's getting dressed (you see her bra and her mostly bare back).
In the promo for the show, they have the camera zero on Laurel's butt, with the audience making wolf noises in response (implying perversion among the male general audience).
Sexual remarks are made, but they're not overtly vulgar.
Violence & Gore
None
The TV pilot's theme (which is argued throughout the whole movie) is about a man's brother who commits suicide. It is not shown, but referenced and brought up a lot.
Profanity
Severe
Close to 40 uses of the f-word, about half of which are uttered by Sigourney Weaver's character. The s-word is most likely used at least 10 times, and other mild profanities are peppered throughout.
Alcohol, Drugs & Smoking
Moderate
Mike collapses, and when he finds out that the network's version of his show is getting used, he begins using his medication in what seems to be a recreational manner, including what appears to be him chasing down a pill with vodka.