UPDATE. The case of geometric distributions seems to be solved: I think we have that for all $\lambda \in (0,1)$, $\mathbb{P}_{p_\lambda}(D(\mathbb{N})) = 0$. But the fundamental question that remains open is: does there exist a probability mass function $p$ of full support, such that $\mathbb{P}_p(D(\mathbb{N})) \neq 0$?
[In this post, $\mathbb{N}$ excludes $0$.]
Given a probability mass function $p$ on $\mathbb{N}$ of full support [i.e. $p(a)>0$ for all $a \in \mathbb{N}$], define the probability measure $\mathbb{P}_p$ on $\mathrm{Sym}(\mathbb{N})$ [the set of permutations of $\mathbb{N}$] by $$ \mathbb{P}_p\big( \pi \, : \, \pi(i) = a_i \ \ \forall \, i \in \{1,\ldots,n\} \big) \ = \begin{cases} \prod_{i=1}^n \frac{p(a_i)}{1 - \sum_{j=1}^{i-1}p(a_j)} & \text{if } a_1,\ldots,a_n \text{ are distinct} \\ 0 & \text{otherwise} \end{cases} $$ for all $n \in \mathbb{N}$.
[To justify that this is well-defined: the Kolmogorov extension theorem gives that this describes an existing and unique probability measure on the set of all functions from $\mathbb{N}$ to $\mathbb{N}$, and it is clear that under this probability measure, almost every function is injective; and we also have that almost every function is surjective, since for each $a \in \mathbb{N}$, the probability that $a \not\in \pi(\{1,\ldots,n\})$ is less than $(1-p(a))^n$, which tends to $0$ as $n \to \infty$.]
Now let $D(\mathbb{N}) \subset \mathrm{Sym}(\mathbb{N})$ be the set of derangements of $\mathbb{N}$, i.e. the set of permutations with no fixed point.
In general, I'm interested to know what we can say about $\mathbb{P}_p(D(\mathbb{N}))$. I'm guessing there exist probability mass functions $p$ for which $\mathbb{P}_p(D(\mathbb{N})) \neq 0$? In particular, if we consider geometric distributions $$ p_\lambda(a) = (1-\lambda)\lambda^{a-1} $$ for $\lambda \in (0,1)$, do we have that $\mathbb{P}_{p_\lambda}(D(\mathbb{N})) = 0$, and if not, then is there a nice formula for $\mathbb{P}_{p_\lambda}(D(\mathbb{N}))$, and what does $\mathbb{P}_{p_\lambda}(D(\mathbb{N}))$ tend towards as $\lambda$ tends to the extreme values of $0$ and $1$?