Fear of bridges over water is a common phobia (it has a name) and can cause serious anxiety.
On some of the longer, higher spans - there are bridge/road personnel assigned to transport anxious drivers to the other side.
If you do a general search on it at Google, you can pull up lots of links. Mine is just a general fear of heights, but I can understand this fear too: