Ha! I was just about to purchase a new blower motor and get prepared to dismantle the inside of the car when I thought I’ll just have another look.
Sprayed the plug on the harness with brake cleaner and slightly bent the pins on the hedgehog to ensure a real good connection.
Plugged in and it works. Doesn’t seem to be noisy either but I only switched the ignition on and off a few times to test it.
Fingers crossed.