If you already had drizzle-orm installed, pnpm exec drizzle-kit push should suffice. This would allow pnpm to refer to the already-installed drizzle-orm and succeed in running.
There is an ongoing discussion regarding this issue on the drizzle-orm repo as well: https://github.com/drizzle-team/drizzle-orm/issues/2699.