I myself do it regularly, especially with contacts who share txt bubble colors.

I haven't had anything that awkward happen but I felt like dying when I ruined the surprise for my best friends birthday party last year by texting the non-secret group chat instead of the secret group chat.