Meole Brace roundabout 'barely fit for purpose' and will 'break' under increased traffic, says transport manager