Northampton's continental romance is ultimately ended by the grim realities of Bordeaux's power, but there is plenty of promise for the future