LOTR question - Who Knew about Frodo's 'failure'?

This.

Only Frodo didn’t fail. His task wasn’t to destroy the Ring; it was to get it to a place where it could be destroyed. I misdoubt that any non-Ainu could have willed the ring’s destruction.