Is science stream is necessary to be a pilot?

No. You only have to take pilot training to become a pilot.

A background including the physical sciences might be a good idea, but it's not, strictly speaking, required. You don't really need to know how the plane works (in terms of scientific principles) to know how it works (in terms of "When I move the stick like this, the plane does that").