I will show that $Y^k$ cannot embed in $\mathbb{R}^p$ when $p < 2k$.
Write $\mathrm{Conf}(2,X) = \{(x,x') \in X^2 \, | \; x \neq x'\}$ for the deleted diagonal of $X$, and note that any injection $Y \hookrightarrow X$ induces an $S_2$-equivariant map $\mathrm{Conf}(2,Y) \to \mathrm{Conf}(2, X)$.
We need the following corollary of Theorem 1.8 from my paper "Configuration space in a product".
If an embedding $A \subseteq B$ induces a homotopy equivalence of pairs $(A^2, \mathrm{Conf}(2,A)) \simeq (B^2, \mathrm{Conf}(2,B))$, then it also induces a homotopy equivalence $\mathrm{Conf}(2,A^k) \simeq \mathrm{Conf}(2,B^k)$ for all $k \geq 0$.
Here is a short proof of the corollary in the case $k=2$.
Two points in $A^2$ are distinct if and only if they are distinct in their first coordinate, or their second coordinate, or both. In other words, $\mathrm{Conf}(2,A^2)$ is covered by the two open subsets $A \times \mathrm{Conf}(2,A)$ and $\mathrm{Conf}(2,A) \times A$, and the intersection of these sets is $\mathrm{Conf}(2,A) \times \mathrm{Conf}(2,A)$. As a consequence, $\mathrm{Conf}(2,A^2)$ is the homotopy pushout of a diagram that depends only on the pair $(A^2, \mathrm{Conf}(2,A))$. By our assumption, the inclusion $A \subseteq B$ induces a pointwise homotopy equivalence on these pushout diagrams, and hence on homotopy pushouts. This concludes the proof for $k=2$; the case of general $k$ requires a larger homotopy colimit, but is otherwise similar.
"Reordering the cars in the driveway twice" gives an equivalence $\mathrm{Conf}(2,Y) \simeq \mathrm{Conf}(2, \mathbb{R}^2)$, (even when restricted to the driveway and a little part of the street, two cars may wind around each other), leading to an equivalence of pairs
$$
(Y^2, \mathrm{Conf}(2,Y)) \simeq (\mathbb{R}^4, \mathrm{Conf}(2,\mathbb{R}^2))
$$
induced by the usual inclusion $Y \subset \mathbb{R}^2$. By the corollary, $\mathrm{Conf}(2, Y^k)$ is homotopy equivalent to $\mathrm{Conf}(2, \mathbb{R}^{2k})$, and moreover, this map is $S_2$ equivariant.
Since $\mathrm{Conf}(2, \mathbb{R}^{p}) \simeq_{S_2} (S^{p-1}, \tau)$, where $\tau$ denotes the antipodal action, and similarly $\mathrm{Conf}(2,Y) \simeq_{S_2} \mathrm{Conf}(2, \mathbb{R}^{2k}) \simeq_{S_2} (S^{2k-1}, \tau)$, any embedding $Y^{k} \subseteq \mathbb{R}^p$ induces an $S_2$-map
$$
(S^{2k-1}, \tau) \to (S^{p-1}, \tau),
$$
which is impossible for $p<2k$ by the Borsuk-Ulam theorem.