Is it really that tough to find someone who doesn’t drink or smoke in today’s world?

Firstly, not a hypocrite here, I myself never smoke or drink. Raised in Army cantt.s with heavy drinking culture around me, I went through the entire Engineering college & concerts & office parties etc. without ever engaging with it. I honestly never figured out the appeal factor in losing all control over oneself. In my 2nd year of college, lost my school friend to a drunk accident and swore to myself to never touch alcohol as respect to him. So, obviously, I had set a few parameters for myself in the dating world to find a partner with similar ideals as me. Just a preference, nothing set in stone. But, nowadays people meet at clubs and bars and over drinks. Their lives, they enjoy; I’ve got no judgements there. Secondly, I hate being lied to. I started dating this girl in Pune who was acting suspiciously very impressed by my college degree, travel tales, work and all. Like I’m a simpleton, and sane enough to know girls want more excitement in their dating life. So, I should’ve taken that as a warning sign but she was from north side as well so, I was blinded by the relatable factor. Anyways, the One thing we agreed to is no drinking. She told me she’s also few months sober now, doesn’t smoke & wants to keep it that way and I happily agreed. Now, first weekend into it, she got blackout drunk at her friend’s birthday party. First break of trust, but her friend was leaving Pune soon, so I understood. Next week, got a phone call to pick her up outside a club and on the way back it was bloodshot red eyes and gradually I decided to end things. Even though everything else was so perfect on paper..but starting this year single again. Is it really that difficult & rare in today’s world? TLDR: How do you find a partner with similar set of ideals as you have? Is it really that difficult in today’s day & age? Should I compromise just to have a shot at a real relationship? Is that what truly loving someone, looking past their flaws mean?