I am looking for (approximate) closed forms for the following expression: $$ {n \choose n/2} p^n = \frac{n!}{(n/2)!(n/2)!} p^n, $$ for a very small constant $p$ (say $p = 1e-5$).
What if $p$ is a function of $n$? (say $ p = 1/n$ or $p = \frac{\log n}{n}$)
You can approximate the central binomial coefficient $\binom{2n}{n} \approx \frac{4^n}{\sqrt{\pi n}} $ using Stirling's formula (the approximation is in the sense that $\lim_{n \to \infty} \frac{ \frac{4^n}{\sqrt{\pi n}} } {\binom{2n}{n} } =1$). Wikipedia link gives you some more information on the error in the approximation if you need it.
You can write $p^n = 4^{n \log_4 p}$ and combine it with the approximation given above to get an approximation when $p$ is a function of $n$.