$\newcommand{\one}{\mathbf 1}$Others have discussed the effect on the estimator (and +1 to Martijn) but I want to more carefully address the effect of adding a constant to $X$ on the rank of $\tilde X$. For the rank of $\tilde X$, it's not the presence of an intercept by itself that matters but whether the constant column is in the column space of $X$.
Let $\one_k$ be the column vector of $k$ $1$s. Then adding a constant $c$ to every element of $X$ can be done by
$$
\tilde X = X + c\one_n\one_p^T
$$
so this is a rank 1 update to $X$. It is indeed possible for this to result in $\tilde X$ becoming reduced rank. For instance, if $c=2$ and the first column of $X$ is all $-2$ then we'll get a column of $0$s in $\tilde X$ which means the rank will be at most $p-1$. I'll let $\mathcal C(X)$ denote the column space of $X$ and I'll assume throughout that $c \neq 0$.
Result 1: If $\one \notin \mathcal C(X)$ then $\tilde X$ is always full rank, or in other words $\one \in \mathcal C(X)$ is a necessary condition for $\tilde X$ to be reduced rank.
Pf: (by contrapositive) we will suppose $\tilde X$ is reduced rank and will show $\one \in \mathcal C(X)$. So if $\tilde X$ is reduced rank there must be some nonzero $\alpha \in \mathbb R^p$ such that
$$
0 = \tilde X\alpha = X\alpha + c(\one_p^T\alpha)\one_n.
$$
Note that if $\alpha^T\one_p = 0$ then we have $X\alpha = 0 \implies \alpha=0$ by $X$ being full column rank, but that's a contradiction, so we must have $\alpha^T\one_p \neq 0$. This means
$$
X\alpha = -c(\one_p^T\alpha)\one_n \implies X\left(\frac{-\alpha}{c\alpha^T\one_p}\right) = \one_n
$$
so there exists a vector $\gamma \in \mathbb R^p$ such that $X\gamma = \one_n$, i.e. $\one \in \mathcal C(X)$.
$\square$
Result 2: if $\one \in \mathcal C(X)$ then there is at most one $c$ such that $\tilde X$ is reduced rank.
Pf: if $\one_n \in \mathcal C(X)$ then there is some non-zero $\alpha \in \mathbb R^p$ with $X\alpha = \one_n$. By $X$ being full rank this $\alpha$ is unique.
Case I: $\alpha^T\one_p \neq 0$.
This lets us do
$$
X\alpha - \one = X\alpha + \left(\frac{-1}{\alpha^T \one_p}\right)\one_n \one_p^T\alpha= (X + c\one_n\one_p^T)\alpha = 0
$$
for $c = \frac{-1}{\alpha^T \one_p}$.
Now for uniqueness, if we are to have any chance of making $\tilde X$ reduced rank we need $X\alpha \propto \one$ otherwise it can't be eliminated. But we can produce a $\gamma$ such that $X\gamma = d\one$ for any $d \in \mathbb R$ (although we'll take $d\neq 0$ since that's for $\gamma=0$). If we do this, then the corresponding calculation for $c$ is
$$
X\gamma - d\one = X\gamma + \left(\frac{-d}{\gamma^T\one}\right)\one_n\one_p^T\gamma = 0
$$
so $c =\frac{-d}{\gamma^T\one}$. But $X\gamma = d\one=d(X\alpha) \implies \gamma = d\alpha$ so actually there is just a single $c$ that works. Thus if $\one \in \mathcal C(X)$ we can find a $c$ that makes $\tilde X$ low rank but there's just one such $c$ so a "random" $c$ is very unlikely to make this happen.
Case II: $\alpha^T\one_p = 0$. Again we'll try to find a $\gamma$ with $\tilde X\gamma=0$, so as before we'll have to take $\gamma = d\alpha$ for some $d$. Assuming we have such a $\gamma$ then
$$
\tilde X\gamma = X\gamma + c\one_n\one_p^T\gamma = dX\alpha + cd\one_n^T\one^T\alpha = d\one \neq 0
$$
so in this special case there is no way to make $\tilde X$ reduced rank.
$\square$
So ultimately it's all about the column space rather than the individual vectors in $X$. If $\one \in \mathcal C(X)$ it's possible to get $\tilde X$ reduced rank, like in my example at the beginning with $c=2$, but in that case this is in fact the only such $c$ that works, so if $c$ is not carefully chosen we probably don't need to worry.
Here's an example where there's no such $c$: take
$$
X = \left(\begin{array}{cc} 1&0 \\ 1&0 \\ 0&-1 \\ 0&-1\end{array}\right)
$$
and note how $\one \in \mathcal C(X)$ and the way to get it is $X\alpha$ with $\alpha = {1\choose -1}$. Thus $\alpha^T\one = 0$. There's no way to make this matrix low rank by adding a constant to it. If we add $-1$ then we eliminate the top half of the first column, but we add to its lower half and the rank is preserved. And etc.