This is why you are taught to oral inflate your BCD, and remove and replace your LP hose, during your OW course. Either one should be a no-brainer, and result in an annoyance rather than an incident or worst, and accident.
Good job of keeping your head screwed on straight and solving the annoyance, and thanks for sharing it.
On a side note, I encourage my AOW students to do a few dives in familiar waters using only oral inflation of the BCD. I tell them that it will show just how much most divers typically over use the inflator button, even when their weight and trim are correct.