I do have an Alhambra, albeit the older generation, at a 2007. What it does very well is move 7 people. But, almost regardless of what choose, 7 people plus any reasonable amount of luggage wont work. There just isn't the room. There is a small amount of space behind the 3rd row in a Q7 or a Discovery, but it is small. Not enough if you were taking some reasonable luggage, to the airport for example, or fitting a pram in there, unless it folded pretty flat, and you could sit it on its edge or something. But enough for a few day bags maybe. But, they are good for carrying the people, as the third row does have a lot of space. I'm a fat fool at 5ft8, and feel there is ample room there for me (my alhambra, and the D4 when I tested one out for a weekend).
This is why I suggested a T6 or even a late T5.1, you get the people carrying, AND still have the space for reasonable amounts of luggage, be that suitcases, or bikes or whatever. The SWB models wont be a huge amount bigger than the likes of an Alhambra or Discovery on the actual road. And while the strong residual values make them expensive to buy, you wont lose as much as you would with almost everything else on offer. You could get a T6 shuttle, less than a year old, with almost £10k off list price (~£25k), but then it'll barely depreciate over the next 2-3 years or so. Certainly less than the likes of a D4 or a Q7, X5 or Kodiaq or whatever. Look at example of T5's that are 10 years old with upto 150k on them, they are still £10k+. They are still quite expensive. Meaning you could buy one, stick 100k on it over 10 years, and it'll cost you, in depreciation, less than £1500 per year. You would lose that £15k in 3-4 years on these other suggestions. Compare that to the depreciation curve on a 1 year old X5 / Q7 / Discovery over 10 years, and you would lose significantly more. Although they will be more luxurious, they wont be as spacious, which it sounds like you want / need.
Or, alternatively, there is the Mercedes R-Class. Probably only 6 seats IIRC, but more of an estate feel to it, and might be a better fit in general, if you don't actually want more of a van, or massive 4x4 with massive 4x4 running costs.