It's just fine- in fact, personally I prefer aquariums because they're sturdier- water is super heavy & they're made to hold water. You can buy a screen top (make sure you get locking clips or preferably find a better way to secure the top- some of those clips can fail- or maybe weren't used quite correctly?) or make your own tops, which is what I do & have done for many years- out of finished pine & "hardware cloth" (welded wire) or perforated metal (one side is very smooth). IF you're keeping a snake that might nose-rub on the top, make sure you use non-abrasive wire mesh or metal for the top. I have a few tanks made for reptiles- that came with sliding screen tops- the tops are flimsy compared to what I make, but when I moved & needed some tanks quickly, I had to settle for a couple of them (& they were also a good deal at the time). But otherwise, aquariums are all I ever buy.And I've never liked or used those locking clips. I'm glad you asked. (Any of my snakes that need better security aren't in the reptile tanks with sliding screen tops either.)
Assuming you're planning to keep a BP in this tank- IF you use a glass tank, be aware that you'll need to block MOST of the air-flow to retain necessary humidity- that's something I don't care about as I don't keep BPs at all- the snakes I keep are fine with more air-flow. Basically you do have options- we don't all do things the same way, & it's fine as long as you create the environment needed by your snakes- the right range of temperatures, & for some species, adequate humidity. And it goes without saying- ESCAPE-PROOF, lol.