Sam and Smeagol

[The Saucepan Man]

Unless, of course, Gollum thinks that by doing this he will be permanently bound to his precious, while at the same time redeeming himself to the master he swore an oath to and ridding himself of fear of the Dark Lord.

But it wouldn't really have been about what Gollum thought or what he wanted to happen. It would have been about him succumbing to the power of the Ring, which most certainly did not want itself to be destroyed.

Frodo at Sammath Naur would, in a proper frame of mind, undoubtedly have thought it a good idea to throw the Ring into the fire below. But, although he was able bravely to resist it for so long, even he succumbed to its will in that final moment and was therefore unable willingly to destroy it. I find it very difficult to see how Gollum would not also have succumbed to the Ring in the same way.