I did a search by Lions Gate Bridge suicides on google and this is what I found it said: "There is a number of suicide bridges in the greater Vancouver area, the most frequented being the Lions Gate Bridge, which saw 324 suicidal incidents, including 78 jumps from 2006 to 2017. ... It is unknown how many deaths have occurred at the bridge, but there have been at least 25 in total, with 10 being from 2012–2013."
So at least 25 suicides and 78 jumps from 2006 to 2017. You can't get to exact numbers from this, but it looks like overall there is likely less than a 50% chance of it working, probably closer to 1 in 3. With about 4 times as many "incidents" as jumps it sounds like the police or others are stopping about 3 out of 4 people who try to make at attempt.
The bridge is 111 feet into water, which isn't high enough to be confident of ctb. If you are ok with maybe a 1 in 3 chance, and you are ready to handle a hospitalization if it doesn't work, that's up to you. If you survive you may be seriously injured.
210 feet into water, if it was that, is 99% fatal based on the golden gate bridge, but jumping there is almost impossible- police swarm any single people walking on the bridge reportedly. Currently only 1 person jumps here every two weeks out of what must be a much higher number who try.
There are higher bridges but none nearby I am sure, and who knows what the access is- searches on google can help to determine this.
Best of luck whatever you choose. :)