Why did gasoline go from being considered useless to being the standard transportation today?

If you can't use something, it is useless. If you can use it well and efficiently, it is excellent. Once people had an easy way to use the gas, it became the standard because it was better than any other method available since.