No, the latter sentence sounds like you are asking youself and are in perplexity finding the trip useless. So the sentence sounds like "Why the hell were we there?"

Meanwhile "Зачем мы ездили на...