Pixel user here too. You have to enable "Google Lens suggestions" in the camera settings for it to read QR codes automatically.
Drop down menu > Camera Settings > Google Lens suggestions.
Drop down menu > Camera Settings > Google Lens suggestions.
So, double press power button, long tap QR code, and click link to visit site.