Back in the 80s, they seemed a viable alternative for the future of computing systems. The RTX2010 [0] found wide adoption in the spaceflight industry.
Since then, however, they seemed to have completely petered out.
Is there any specific reason?
[0] https://en.wikipedia.org/wiki/RTX2010
But both of them lost out to many-general-purpose-registers based CPUs, because that's what you need in order to write code which has many instructions in flight at once (for superscalar, pipelined, or both). If you look at the FPU on the Pentium you see the nightmare you run into otherwise -- optimized Pentium x87 code is half FXCH (swap the top of stack with something else) instructions because the FPU was pipelined and so you had to keep shuffling your stack in order to avoid pipeline stalls. The Pentium FPU has a hefty register-renaming unit in order to make this work; if it had been designed with general purpose registers rather than as a stack, that would have been avoided.