It looks like a missed opportunity by the Council and Network Rail. That bridge is overused by large lorries visiting the works and by residental traffic, the road surface is terrible too.
The two main issues are width and angle of the road. It is too sharp on both approaches, being literally 90 degree bends and the bridge isn’t wide enough for proper 2-way traffic and pedestrian or cyclists. There is no pavement for the majority of Campbell Road.
The solution is to do it properly. The angle of the bridge needs to be reduced which can be solved by slewing the angle of the bridge. A wider new bridge would ensure it is future-proofed by adding a proper pavement. Network Rail have the land for it and to widen the current road to ensure a pavement continues longer.