Actually, I do know of exceptions to this, that's when $d$ is prime in $\Bbb{Z}$, e.g., $\Bbb{Z}[\sqrt{-79}]$ has class number $5$ and $\mathcal{O}_{\Bbb{Q}(\sqrt{79})}$ has class number $3$, but obviously $\sqrt{-79}$ and $\sqrt{79}$ have prime norms and are thus primes in their respective domains.
But if $d$ is a negative composite number, say $d = -pq$ (where $p$ and $q$ are positive primes) then obviously $p$ and $q$ are both irreducible but neither is prime. And what if $d = pq$ or some other positive composite number?
I've worked through a few specific examples. Like in $\Bbb{Z}[\sqrt{-10}]$, norms $2$ and $5$ are impossible, so $10$ has two distinct factorizations. And in $\Bbb{Z}[\sqrt{10}]$, it is easy to see that $2$ is irreducible, though it takes a little more work to show that $5$ is irreducible as well.
Obviously this is too laborious, especially if the smallest counterexample is some number with a thousand prime factors.
Also, I'm not sure why last night I was looking up "real quadratic fields of generalized ERD-type" (a paper by Xianke and Fuhua only left me more confused). Does anyone even know what ERD-type is?
But my main question is this: can $d$ be composite in $\Bbb{Z}$, $\mathcal{O}_{\Bbb{Q}(\sqrt{d})}$ has class number greater than $1$, yet $\sqrt{d}$ is composite in $\mathcal{O}_{\Bbb{Q}(\sqrt{d})}$?
Based on Sloane's A051990, I would guess it's $\mathcal{O}_{\mathbb Q(\sqrt d)}$ such that $d = r^2 k^2 + k$ with $k$ odd. Hopefully someone else can give a definitive answer to that side question.
Absolutely. If the class number is 1 and $d = pq$, then we know that $\langle p \rangle$ can be factorized as principal ideals, and the same goes for $\langle q \rangle$. Just because the class number is 2 or greater doesn't mean that still can't happen, though the evidence of small numbers suggests that more frequently than not it doesn't.
So for example, as you noted in a comment, $(4 - \sqrt{14})(7 + 2\sqrt{14}) = \sqrt{14}$. Looking at ideals, we see that $\langle 2 \rangle = \langle 4 + \sqrt{14} \rangle^2$ and $\langle 7 \rangle = \langle 7 + 2\sqrt{14} \rangle^2$, so then $\langle \sqrt{14} \rangle = \langle 4 + \sqrt{14} \rangle \langle 7 + 2\sqrt{14} \rangle$. You know about ideals, right?
Okay, so with 10, we see that $\langle 2 \rangle = \langle 2, \sqrt{10} \rangle^2$ and $\langle 5 \rangle = \langle 5, \sqrt{10} \rangle^2$. Not principal ideals, so we can't pick and choose factors of the generating numbers to factorize $\sqrt{10}$ as a number.
Compare 34. Check that $(1 - \sqrt{34})(1 + \sqrt{34}) = -33$, yet 3 and 11 are both irreducible, so $\mathbb Z[\sqrt{34}]$ must have a class number of at least 2.
But $\langle 2 \rangle = \langle 6 + \sqrt{34} \rangle^2$ and $\langle 17 \rangle = \langle 17 + 3\sqrt{34} \rangle^2$, so $\langle \sqrt{34} \rangle = \langle 6 + \sqrt{34} \rangle \langle 17 + 3\sqrt{34} \rangle$, and then to factorize $\sqrt{34}$ it's a simple matter of shopping the signs.
I don't know of any clever way to go from, say, $\langle 2, \sqrt{34} \rangle$ to $\langle 6 + \sqrt{34} \rangle$, and the textbooks are no help, since their authors generally prefer not to see the trees from the forest. All I can say is try to solve equations like $x^2 - pqy^2 = \pm p$.
Cross-checking A051990 with A029702 (when you get to 79 you'll need to also look at A029703), we find that in $\mathbb Z[\sqrt{51}]$ the ideal $\langle 3 \rangle$ does not split into principal ideals, so your insomniac theory about ERD-type rings might just be a red herring.