You can walk under the bridge now (on the Riverview side). It's kinda neat, and a great observation spot for the river.
There is a boat launch at the bridge on the Moncton side, and there is a connection under the bridge there too, but I don't know how that will tie in with the reconstructed trail system yet. I would be very surprised however if there is not a connection planned.