Karim, I like the vision. I'll definitely be following along. My thoughts:
What sort of powerheads are you talking about using that are reversible for the wall of powerheads? Or will you just be shutting some off and others on to achieve flow reversal? It seems that actively reversible units would be much preferable.
I would suggest building a "porthole" into the false floor, and making the false floor out of PVC like some tank bottoms are made. You could be more cavalier with placing structure on it, and if you had a rectangular cutout with a countersunk panel in it, if anything ever went south in the below area, you could just siphon out the sand (you would have the forethought not to cover the porthole with rock) and then lift the lid to access below.
I like the surges, but that is a massive amount of surge. You will have to run the tank with a pretty low water level to keep from flooding during a surge event, since the siphons will take a second to get cracking, unless you taper the surge on and off, which defeats the purpose of a surge a bit. Consider perhaps leaving your drains as is, and making one big-bad emergency drain, that has a large collector, and perhaps two pipes, and when your surges dump, the drains all max out (without having to be adjusted) and the emergency drain just handles the rest. That way you arent constantly adjusting the drains to handle the surge, which sounds like a point of failure.
For cooling, I would consider burying a large caisson in the backyard and filling it with a non-freezable liquid (antifreeze and water?). Then you could circulate that fluid through your sump to cool the system when it is too hot, and possibly circulate that fluid through your air intake to the fish room to cool the room. I am unsure how large a caisson you would need to get you through the summer months, as it would slowly warm, but if you put it deep enough, ground temperature will keep it cool. I think that this is a better method, with a larger heat sink, than just running pipes underground. I have always thought a large subterranean volume would be the best method of geothermal cooling, plus you could just leave it dormant during the Texas winter and fire it up again in summer.
Definitely make that removable section that houses the powerheads beefy with large handles so that you can pull it out without breaking anything. Perhaps consider PVC for the back of the tank and the dividing wall in front of the flow walls? I shudder to think of glass passing by glass when you need to remove that flow segment for maintenance on a regular basis.
With regard to the sunroom, I am not wise in radiated heat and light spectrum, so you are on your own there! Perhaps an automated shade shutter system could activate on the hottest days everywhere except for over the tank?
One thought I had is that the many many pumps you have there for flow is a maintenance nightmare. Is there a better way? Like one massive pump for each quarter (top, bottom, left, right) and it has many outputs? Or just opt for a flapper style wavemaker instead? One feature that is unique about your situation is that you have an open loop (top, down, bottom, back up), so if you put a large paddle in the back, and actuated it up and down in that volume, it would force a LOT of water to cycle either clockwise or counterclockwise. If it had a long enough throw, it might actually make for awesome alternating flow. I just like the idea of a single actuated control surface since it has one system to maintain instead of 40 separate systems.
Honestly I don't think the heating and cooling will be murder. I do think that in the interest of complexity though, it may be wise to either do a large surge, or a large wavemaker, and not both. The permutations of a system with both are many and it seems like a lot of work to have two systems that achieve basically the same thing, chaotic flow at times and smooth flow during others. For example, you could simply use just a surge, have returns on the top facing out, and returns on the bottom facing out, you could actuate just the top ones slowly for standard flow, fast for surge clockwise (out-down-back-up), and then actuate just the bottom ones slowly for reverse standard, and fast for reverse counterclockwise. I think in a manner like this, you could achieve steady laminar flow, fast chaotic flow, and multiple directions, without a ton of pumps (just a few actuated valves).
I think it wise to also consider livestock, a wall of pumps running fast will take a lot of getting used to for much of the livestock, but a few dispersed surge outlets are less likely to splat a weak swimming fishy.
The outdoor algae scrubber idea is really cool. Evaporation may be a serious consideration, but it sounds like you could use the evaporative cooling anyway.
One other thing that comes to mind to close out this novel I've written is the hydro-wizard pumps. Big money, but they push a ton of water and could achieve large flow with just one pump as opposed to so many.
Oooh ooh one more idea, and this one is kind of off the walls, but i've never seen this done for fishtanks. We used to use these for thrusters on deep sea ROVs because they thrust and don't foul (Rim Driven Thruster):
You could just have one LARGE pipe exiting one end of the tank, a large diameter tube running back to the other side, and the thruster in the middle of that tube, and then have it return to the other end of the tank. Fish could safely travel through the chute (i think as long as you left a large enough space between non-aggressive blades) and you would basically have an endless current. Man I kind of want to try it.