I believe everybody knew there was not going to be a mountain. But people are curious creatures. The main question became: can it be done?
It is interesting a lot of money was put into the project while most people knew there would never be a mountain. But they learned so much from it. So I think you can't say it was a waste of time and money.
But for the coming years I still believe the Netherlands (lower countries) will remain flat.