You noticed the can tab
Why Do Soda Can Tabs Have Holes?
The hole in a can tab is not just for your finger. It helps the tab act like a lever so a small lift can punch open the lid.
Quick answer
The hole in a soda can tab gives your finger a place to grip and helps the tab work as a tiny lever. When you lift the tab, it pivots around the rivet and pushes the scored part of the lid open.
The straw trick is real, but it is a bonus use. The main purpose of the tab hole is opening the can.

Main job
Open the can
Mechanism
Lever + rivet
Bonus use
Straw holder
Not only for
Decoration
Next tiny mystery
More things hiding in plain sight

You noticed the tiny hole
Why Do Pen Caps Have Holes?
Another tiny hole people often misunderstand.

The thing on your foil box you never pressed
What Are the Tabs on Aluminum Foil Boxes For?
Another packaging feature people often miss.

You noticed the extra holes
What Are the Extra Holes on Shoes For?
Another useful hole hiding in plain sight.