You cannot plug a Wii Classic Controller directly into an N64 console. The ports, signaling, and pinouts are completely different.
For authentic feel: original N64 controller or 8BitDo M30 / Retro-Bit Tribute. For comfort + wireless: 8BitDo Pro 2 + Retro Receiver. For emulation: Classic Controller via Bluetooth is excellent.