firsthand interview questions

Had two rounds. The first interviewer gave insights on the role and expectations, from having to lead Product development to day to day work. Since it was a small team this was expected. The interviewer was pleasant. Also asked some generic questions about DBT. The second round was technical focusing on a SQL challenge in Snowflake. This time around, the interviewer was not pleasant and seemed really disinterested. Throughout the interview interviewer was vaping and also did not provide a clear question and at times had to clarify. The question was straightforward and I answered it correctly. The interviewer stated I did well and explained to me what the next round will consist of and how to prepare. I was excited about this role and this company's mission and decided to prepare before the interview was finalized. I didn't hear back for a few days and reached out to the recruiter only to be told that I didn't make to the next round. I was devastated and felt as if I was mocked. Looking back at how unprofessional the interview went and the fact this was a mission driven organization, Made me question how employees are treated and more importantly, the clients they serve.