It's pretty inevitable that we get widespread electric car use at some point. Give it 10-15 years.
Sports cars are a weird branch of engineering, and we've gotta walk before we can run, so don't hold your breath for more Tesla Roadster types.
Water isn't a fuel, I don't know where you got that idea from. Maybe you misunderstood the concept of Hydrogen fuel cells? The main problem with those at the moment is hydrogen storage and hydrogen production. Thousands of chemists are working on hydrogen storage molecules, and also "artificial photosynthesis" catalysts, which would split water and CO2 to give H2, O2 and remove CO2 from the air.
Steam cars, well, they didn't catch on a hundred years ago, and I don't really see people shovelling coal into their sedan

For lorries or buses, well, possibly, if electric types are not available in time it might be a stopgap measure.
If artificial carbon-neutral oil from algae or similar tech becomes viable then maybe we'll never see electric cars.
Maybe the whole concept of a car as something anyone can own will be a passing phase in history, if none of the problems are sufficiently solved. Publicly owned mass-transit-systems, yeah, but no cars.