Why did God forbid the use of alcohol in Islam? And why at first was it allowed in one ayat, banished in other

Because when you drink alcohol, you forget about Allah. And say, you p out or even die..You aren't gonna remember to say the shahada since you're mind is somewhere else