I heard they have pipes that big at the Liverpool cathedral, but they only use them when the Queen was there, as they are literally wrecking the cathedral.
https://www.liverpoolcathedral.org.uk/media/qyyd3x40/liverpo...
I totally get why they would want to limit the use of that particular register. At that frequency you're putting standing waves in the structure of the cathedral that are long enough to put significant stresses on the masonry. I've played around a bit with a 32' stop in a church and that already had me worried about the stained glass and the more delicate bits of stone work. Half that at volume must be very impressive.