Why does the carbocation in this scheme react under elimination conditions rather than being attacked by water? In the final step of the mechanism, elimination occurs over substitution, why is this?
The simple answer is that water is a very weak nucleophile and substitution does happen reversibly, but usually dissociates immediately. After which, the final reaction shown happens.

There is likely a (very) minor product that follows along the substitution pathway with an alcohol final product.