If everyone realized one day God wasn't real, would we make a leap in new science discoveries?

Yes, because the money spent in religious institutions would go in funding for scientific research. More peace in the world. Democracy secularism and science.

We shall invent warp drive in a year, and establish the Starfleet Academy

The important word in your question is - everyone -.

If everyone is of the same opinion then tremendous things can be done.

I think this was a good question - try to keep up thinking !

No a lot of scientists are religious so we might even lose some people Peoples inner stories ont affect their capacity to be scientific - its mostly just where they put the credit.

Too bad God is real. Religion and science go hand in hand. Enough said.

In other words,

No.

Science is the study of what is there in Creation. Then science discovers already existent things, uses them in adapting to the laws referring to the things they discovered and as they adapt to what they find, humans can use it to their benefit. But humans always have to adapt to what already exists.

These things are already there, and no human being has done them or created them, a human being cannot even create a piece of sand.

So all what science does is researching physical reality, it researches GOD's Creation as humans have not created what they find, but humans can use Creation to the benefit of others, or can use it to destroy others, as GOD gave us our Free Will.

In that I am not getting your point.

If not for Luther the church would have collapsed from corruption and we would have landed on the moon in the 1700's.