Wikipedia here describes for $X = (X_1,...,X_n): \Omega \rightarrow \mathbb{R}^n$ with each $F_k(t) = P(X_k \leq t)$ continuous, there is a pushforward measure induced on $[0,1]^n$ via $(F_1(X_1),...,F_n(X_n))$. Using this measure, one finds $Y(u_1,...,u_n)=(F_1^{-1}(u_1),...,F_n^{-1}(u_n)), \ \forall (u_1,...,u_n) \in [0,1]^n$, has the same distribution as $X$.
When Sklar's theorem is described, it appears that it is no longer assuming each marginal $F_k$ is continuous. This makes me wonder why they assumed it in the first place.
Does Sklar's theorem or a related theorem imply for $(X_1,...,X_n)$ (where the $F_k$ are not continuous) there exists a nice measure $\mu$ on $[0,1]^n$ and $Y: [0,1]^n \rightarrow \mathbb{R}^n$, $Y(s_1,...,s_n) = (Y_1(s_1),....,Y_n(s_n))$, with the same distribution as $X$?
Yes, Sklar's theorem holds for all distributions.
For every multivariate cumulative distribution function (cdf), there exits a copula with cdf $C: [0,1]^n \rightarrow [0,1]$ such that:
$$F(x_1,...,x_n)=C \left (F_{X_1}(x_1),..., F_{X_n}(x_n) \right).$$
A copula is any multivariate distribution whose univariate margins are uniform distributions on $[0,1]$.
When, the margins have discrete distributions, it is not easy to find the underlying copula (while there is one); see Section 2 of this paper. However, you can easily use any copula to construct a multivariate distribution with arbitrary univariate margins.