New research debunks the ‘unhappy worker’ narrative, but finds most still believe it