Google Voice Search used internal codename "Majel" in reference to Majel Barrett, who played the voice of the Star Trek computer. That was explicitly the ambition. It just didn't work out.
Is that a story of failure or of success?
Starbucks launched to sell beans and espresso machines. YouTube launched as a video dating site. Are they also failures?
I think people see more than $30 of value in them, at least as their revealed preferences suggest.
(I'm deliberately excluding the "ten words to 'author' a holodeck scene" part, that had always been stretching my imagination a little too far, more "this can't work!" than space travel and transporter beams. Then stable diffusion happened)
I believe it is possible to have made it better, but they didn't try, they just gave up, like much of google products.