Your understanding is more-or-less right about the Chandrasekhar mass. The maximum mass is likely to be a little lower than $1.4 M_{\odot}$ because collapse or explosion may be triggered by either General Relativistic instabilities, inverse beta decay or by pyconuclear reactions, that all commence when the (central) density reaches $\sim 3\times 10^{13}$ kg/m$^3$ in a Carbon/Oxygen white dwarf, corresponding to a mass of about $1.38 M_{\odot}$ (e.g. Rotondo et al. 2011 and https://physics.stackexchange.com/a/345296/43351 ).
A Type Ia supernova might be triggered if a white dwarf close to this limit accretes more mass from a companion, or by the merger of two white dwarfs. The trigger for the explosion could be pyconuclear reactions between carbon nuclei in a dense crystalline lattice at the centre of the white dwarf, or it might be caused by the ignition of helium (from the accreted material), which can occur at lower densities nearer to the surface (see https://astronomy.stackexchange.com/a/14747/2531).
There is a very non-linear relationship (see plot below) between the initial mass of a star and the white dwarf it will eventually become. For instance it is thought that the Sun will leave behind a $\sim 0.5 M_{\odot}$ white dwarf, but a $1.1M_{\odot}$ white dwarf will have had a progenitor of $\sim 8M_{\odot}$. The white dwarf is essentially the ashes from the nuclear-burning core of the star, which can form a relatively small fraction of the initial mass. This "ash" never gets hot enough to burn, because electron degeneracy pressure halts any further contraction.
The big difference in mass of the progenitor and the white dwarf it leaves behind is due to mass loss, mainly in the red giant phase and the asymptotic giant branch phase, due to dusty, radiation-driven winds. These wind expel the majority of mass above the degenerate core. White dwarfs that are very close to the Chandrasekhar mass cannot be produced by normal stellar evolution, without interference or mass transfer from a binary companion.

Stars up to $8M_{\odot}$ will probably leave behind a degenerate core of carbon and oxygen. It is possible that slightly heavier stars may be able to leave degenerate cores of Neon or Magnesium, without burning further towards iron. Most researchers agree that beyond $10M_{\odot}$ that the most likely final outcome will be a core of iron-peak elements that collapses yielding a Type II supernova. All of the above mass limits may be slightly dependent on the initial chemical composition of the star.
The outcome of a Type Ia supernova is the complete destruction of the white dwarf, since the energy released is larger than the gravitational binding energy of the white dwarf (see https://physics.stackexchange.com/a/346092/43351). Type II supernova might leave behind a remnant neutron star or black hole. There are no supernovae which leave behind a white dwarf remnant.
Edit: As Peter Erwin suggests, one-way of thinking about the above processes is (roughly) that a white dwarf gets left behind if the mass of the core is less than the Chandrasekhar mass for its composition. This is satisfied for $\leq 8M_{\odot}$ stars, since the core mass is $<1.2M_{\odot}$, which is comfortably below the Chandrasekhar mass for degenerate C, O, Mg or Ne.
For higher mass stars, the core mass will be higher, but the Chandrasekhar mass for iron is lower, about $1.2M_{\odot}$. Therefore a white dwarf cannot be the final outcome for such stars.