An important point to bear in mind is that there are moorings in Pill Creek, and
@AlastairFraser's proposed site is straight throug a sailing club on the Gloucestershire bank. (The Severn is top Left, bristol bottom right on this image).
View attachment 167158
On the shirehampton side, shifting the bridge and slipway around to get the bridge upriver of the slipway should be easy enough, but moving the bridge to the other side of the creek on the Somerset bank isn't as there are houses right on the bank.
Therefore, any bridge would need to balance the clearance against the likely require openings for boat traffic. And also the operating costs for such openings. I don't know how many boats moored in Pill Creek are masted, but given the other bridges in Bristol itself I'd probably go for a 4.5-5m clearance above high water, which given the width of the river at this point shouldn't be too steep to provide over the navigable channel.
https://www.bristol.gov.uk/resident...vigation-in-the-harbour-and-bridge-clearances
However, as a comparison, the new Govan-Partick Bridge in Glasgow that opened recently has a moving span of 99m and cost nearly £30m.
https://www.bbc.co.uk/news/articles/c24pm9zjq20o#:~:text=A new Govan-Partick bridge,and cycle bridges in Europe.