Google and others have used the term Moonshots to define highly ambitious technological projects and a mindset

Google and others have used the term Moonshots to define highly ambitious technological projects and a mindset of big goals.
What is the history and the future of actual moonshots?
There were 6 manned landings on the moon.
There were 62 other successful moon missions with a combination of robotic landers, orbiters, sample return missions, flybys and gravity assists.
There were 60 failed moon missions. There were 36 launch failures and 21 spacecraft failures and a few partial failures.
There are now 23 funded moon missions. There are 19 unmanned moon and four planned manned moon missions over the next 5 years.
There are 9 proposed but unfunded unmanned missions and four other proposed manned moon programs in the 2030s.
There are four SpaceX Falcon 9 missions and one Starship mission (Dear Moon – Japanese Billionaire).
From 2024 onwards, the 2023 Starship mission and having dozens of fully reusable Super Heavy Starships will open the door to regular moon missions.
The historically best year for moon missions was 7 successful missions in 1967. There were four successful missions in 2007. There are five missions planned for 2020 and 6 for 2021.
Elon Musk has the goal of building 100 Starships every year.
If SpaceX is able to convert existing Merlin Engine plants to building Raptor engines, then they could build about one dozen Super Heavy Starships each year. SpaceX can build about 500 engines a year.
Building 100 Starships/year gets to 1000 in 10 years or 100 megatons/year or maybe around 100k people per Earth-Mars orbital sync
— Elon Musk (@elonmusk) January 17, 2020
SpaceX could price moon missions with a fixed cost of $100 million. This price would cover loss of the rocket one out of every three landings. Moon missions would become safer and more reliable by building landing pads on the moon.
NASA is spending about $10+ billion for each SLS (Space Launch System) moon mission.
Even with $400 million for the mission portion and $100 million for the launch, $6 billion per year would be enough to fund monthly manned missions to the moon.
This would support the construction and operation of large manned bases on the moon.
The Zubrin moon direct plan describes the establishment of operations for producing fuel from ice with just two Falcon Heavy missions.
Fuel produced on the moon would mean sub-orbital hopping that explores the entire lunar surface.
The cost of unmanned moon flights would drop towards the $5-10 million incremental cost of a reusable SpaceX Super Heavy Starship.
Unmanned moon missions could become a weekly and even daily occurrence in the late 2020s.
Brian Wang is a prolific business-oriented writer of emerging and disruptive technologies. He is known for insightful articles that combine business and technical analysis that catches the attention of the general public and is also useful for those in the industries. He is the sole author and writer of nextbigfuture.com, the top online science blog. He is also involved in angel investing and raising funds for breakthrough technology startup companies.
He gave the recent keynote presentation at Monte Jade event with a talk entitled the Future for You.  He gave an annual update on molecular nanotechnology at Singularity University on nanotechnology, gave a TEDX talk on energy, and advises USC ASTE 527 (advanced space projects program). He has been interviewed for radio, professional organizations. podcasts and corporate events. He was recently interviewed by the radio program Steel on Steel on satellites and high altitude balloons that will track all movement in many parts of the USA.
He fundraises for various high impact technology companies and has worked in computer technology, insurance, healthcare and with corporate finance.
He has substantial familiarity with a broad range of breakthrough technologies like age reversal and antiaging, quantum computers, artificial intelligence, ocean tech,  agtech, nuclear fission, advanced nuclear fission, space propulsion, satellites, imaging, molecular nanotechnology, biotechnology, medicine, blockchain, crypto and many other areas.