The turning for the Orchard/SS Great Britain is before the bus gate so you can still drive to the Orchard
From BCC : The bus gate will be installed immediately to the east of Gas Ferry Road, so cars can travel eastbound on Cumberland Road up to this point, which also means access by road to the SS Great Britain will be retained from both directions
Cumberland Road stabilisation and bus gate update (bristol.gov.uk)