By the way, it is possible for multiple people to combine pensions into one pot to do something like this but I don't know the detail as it wasn't necessary for me.
Yes, you can do it like that and you don’t have to all invest the same amount. However the costs of running that sort of SIPP or SSAS? can be quite high (admin costs informing all the pension holders about rent collected etc etc).
My other half and his partners bought a couple of freehold buildings that their business part-occupied. The income/costs/sale proceeds were all in proportion with their % ownership of the partnership at the time when each building was purchased. They paid off the mortgage with a market value rent from the partnership and also from the tenants in other parts of the buildings.
In the Sportsitalia scenario, I suppose the way to do it is everyone invests a chunk to purchase a freehold outright and then SI pay a nice juicy rent. Otherwise it isn’t worth it! Unless it is a large site with redevelopment potential further down the line when Matt retires…..