The concept is cool but I would absolutely not trust that not to be pulled apart by a snake and have it on the loose in the house. Gerbils have a lot less muscle and managed to get out all the time when I was a kid with those tubes. I could see some awesome possibilities with custom acrylic tubes though which were sealed properly with solvent! Cleaning might be a pain on the other hand though if they don't come apart, so I'd make them wider and have some sort of special flange where they connect to the lids that was really hard to disconnect them from inside.
Dav Kaufman tours a house with some really neat custom enclosures, like a glass table with a huge enclosure beneath and some other cool ones. https://www.youtube.com/watch?v=QFvtP95GNRo