It's not only about prestige.Its a failure if its not achieved amd waste of money and what you gain by landing on moon for a tag of super power? While condition of live style in india is totally opposite as compare to super power countries.
What is gained is an understanding and a progression in technology. There will be numerous scientific, engineering, metallurgical, chemical, electronic, IT, astronomic, mathematical challenges to be overcome to mount such a mission even if, on this occasion, it has ended in failure.
The technology acquired will be transferable to many fields and industries, both civil and military.
Knowledge is never wasted.
I wish Pakistan was wasting money in this way.