Call $X$ the one point compactification of $S^5\times \mathbb{R}$. Actually, I'll write $S^5\times (0,1)$ instead. Since $(0,1)$ and $\mathbb{R}$ are homeomorphic, this doesn't change the problem.
Let $\Sigma S^5$ denote the suspension of $S^5$ and let $Y$ be the quotient of $\Sigma S^5$ obtained by gluing the two cone points together.
Proposition The space $X$ is homeomorphic to $Y$.
Proof: View the suspension as $S^5\times [0,1]$ with $S^5\times \{0\}$ and $S^5\times \{1\}$ both collapsed to a point. Let $f:S^5\times (0,1)\rightarrow Y$ be the composition $$S^5\times (0,1)\rightarrow S^5\times [0,1]\rightarrow \Sigma S^5\rightarrow Y.$$
The first map has image everything except $S^5\times \{0,1\}$, but these points all get identified to a single point in $Y$. Thus, this composition provides an embedding from $S^5\times (0,1)$ to $Y$ which misses a single point. Since the closure of $S^5\times (0,1)$ in $S^5\times[0,1]$ is everything, it follows that the image of $f$ is dense in $Y$. Since $Y$ is compact, it is a one-point compactification of $Y$. However, one point compactifications are unique up to homeomorphism, so $X$ and $Y$ are homeomorphic. $\square$
So, we just need to show that $Y$ is not a topological manifold. In $\Sigma S^5$, take two small neighborhoods, one around the top cone point and another around the bottom cone point. Their projections $Y$ give two open sets in $Y$ which intersect only in a single point.
But this cannot happen in a manifold: taking a topological chart around the intersection point, we obtain a point in $\mathbb{R}^n$ with neighborhoods $U_1$ and $U_2$ intersecting at a single point $p$. By definition, there is a ball $B(p,r_i)\subseteq U_i$ for some positive radii $r_i$. But then if $r = \min\{r_1,r_2\}$, $B(p,r)\subseteq U_1\cap U_2$. That is, the intersection contains more than one point.
Thus, $Y$, and therefore $X$, cannot be a topological manifold.