You’re not alone. I had the same problem on my 2009 throughout the years.
Same routine, open my window slightly if my keys are in the ignition. Remind the kids to not close the doors if they leave the vehicle.
Just got use to this annoying gremlin. Usually happens months apart. Definitely not a weekly thing. Usually shows up after long stretches of not happening.
I think only once did I have to retrieve my actual non-fob key spare when the doors locked with the darn keys inside.