Texas here, and no, not in most places and settings that aren't bars clubs and restaurants. Although, as long as they're not getting trashed most people will have some beers in the cooler and just keep them in coozies so they could conceivably be soft drinks. Nobody pretends to be fooled by the plausible deniability, but this would be mostly in local or state parks where you might fish or picnic, and again, hopefully not to the point of drunkenness. Because everything in Texas is a minimum 20-30 min drive we have a high DUI rate though, unfortunately. All that aside, people have already pointed out it depends. The south and Midwest or anywhere that could be considered 'bible belt' are going to have stricter laws on the books. That said, if you're drunk in public and have people that care about you, you'll probably just get an Uber home. You mostly see these laws applied to belligerent drunks causing problems or being disruptive. I've seen a guy get bounced, try to fight the bouncer in the street, then 3 off duty fire fighters backing him up, and finally the police that showed up, for example.

Edit: actually, it's worse than you think here lol, we have "dry counties" where it's not illegal to drink but IS illegal to sell hard liquors in stores. Restaurants etc. still sell alcohol. Bottle shop is a county over.