If everyone was responsible then yes, but we know that ain't happening.
I think dropping the beer ban would create more problems. There would be more drunks guaranteed, and it would make it harder for our children to enjoy it, with idiots that cant hold their liquor. I don't want my kids experience of a Alabama football game being some drunk, cussing, spilling beer, and creating a overall bad enviroment for them. Part of the whole experience to me, is bringing my young sons to a Bama game and them enjoying it and having a memory for a lifetime with each other. Not the memory of the drunk falling down and puking on himself.
Just my 2 cents.