The attachment may be in a "Pending acceptance" state and you need to go in the console, on the account that contains the transit gateway and accept the request in the Transit Gateway Attachments tab.