In short terms:
Your assumption is correct. If the definition of mole would have been based on 24 grams of carbon-12, all molecular weights would double. This is not the case and I highly doubt, that this definition will ever change.
In long terms:
This question is very definition specific. One should not be confused with the several types of definitions. All these definitions are based on the carbon-12 isotope. Hence the atomic mass (constant) has a specific value:
One twelfth of the mass of a carbon-12 atom in its nuclear and
electronic ground state, $m_u = 1.660 5402 10~\times~10^{−27}~\text{kg}$. It is equal
to the unified atomic mass unit.
The unified atomic mass unit is therefore a derived non-SI unit:
Non-SI unit of mass (equal to the atomic mass constant), defined as
one twelfth of the mass of a carbon-12 atom in its ground state and
used to express masses of atomic particles, $u\approx 1.660 5402 10~\times~10^{−27}~\text{kg}$.
The atomic weight (i.e. relative atomic mass) is a ratio (=number) and therefore has no unit:
The ratio of the average mass of the atom to the unified atomic mass
unit.
Also based on carbon-12 is the definition of mole, which you stated correctly:
SI base unit for the amount of substance (symbol: mol). The mole is
the amount of substance of a system which contains as many elementary
entities as there are atoms in 0.012 kilogram of carbon-12. When the
mole is used, the elementary entities must be specified and may be
atoms, molecules, ions, electrons, other particles, or specified
groups of such particles.
Derived from this is the Avogadro constant:
Fundamental physical constant (symbols: $L$, $N_A$) representing the
molar number of entities: $L = 6.022 141 79 30 \times 10^{23}~\text{mol}^{−1}$.
Therfore one can derive several other commonly used properties, such as molecular mass and molar mass. In a biannual publication "Atomic weights of the elements" are published by IUPAC. In Pure Appl. Chem., 2013, Vol. 85, No. 5, pp. 1047-1078 (or here) it says:
The atomic mass, $m_\text{a}$, of an unbound neutral atom of
carbon-12, $m_\text{a}(\ce{{}^{12}C})$, in its nuclear and electronic
ground states is $12~u$ exactly, where $u$ is the unified atomic mass
unit. The atomic weight (also called the relative atomic mass) of
isotope $^i\text{E}$ of element $\text{E}$, symbol
$A_\text{r}(^i\text{E})$, in material $\text{P}$ is
$A_\text{r}(^i\text{E})
> =\frac{m_\text{a}(^i\text{E})_\text{P}}{\frac{1}{12}m_\text{a}(\ce{{}^{12}C})}=\frac{m_\text{a}(^i\text{E})_\text{P}}{u}$
Thus, the atomic mass of $\ce{{}^{12}C}$ is $12~u$, and the atomic
weight of $\ce{{}^{12}C}$ is $12~$ exactly. All other atomic weight
values are ratios to the $\ce{{}^{12}C}$ standard value and thus are
dimensionless numbers. The atomic weight of element $\text{E}$,
$A_\text{r}(\text{E})$, in a material $\text{P}$ is determined from
the relation
$A_\text{r}(\text{E})_\text{P}=\sum\left[x(^i\text{E})_\text{P}\times A_\text{r}(^i\text{E})\right]$
where $x(^i\text{E})_\text{P}$ is the mole fraction of isotope
$^i\text{E}$ in material $\text{P}$ (also called the isotopic
abundance).
Therefore the standard atomic mass of carbon is (given in an interval)
$m_{\text{a}}(\ce{C})=A_\text{r}(\text{C})_\text{graphite}\times u = [12.0096, 12.0116]u$, with
$u=\frac{1}{12}m_\text{a}(\ce{{}^{12}C})$.
However, the atomic mass of a single molecule is always an integer multiple of $u$.
The molar mass of carbon can then be defined as
\begin{aligned}
M(\ce{C})&=m_{\text{a}}(\ce{C})\times L\\
&=[12.0096, 12.0116]\times10^{-3}~\text{kg/ mol}\\
&\approx 12.01~\text{g/ mol}~\text{(4 s.f.)}
\end{aligned}
The whole relation becomes a little bit clearer when looking at bromine. There are two important Isotopes of bromine: $\ce{^{79}Br}$ and $\ce{^{81}Br}$ (ref). So in elemental bromine ($\ce{Br2}$) the molecules may have three different masses $m_{\text{a}}(\ce{^{79}Br2})=158u$, $m_{\text{a}}(\ce{^{81}Br2})=162u$ and $m_{\text{a}}(\ce{^{79}Br^{81}Br})=160u$.
The standard atomic mass of bromine is $m_{\text{a}}(\ce{Br})= [79.901, 79.907]u$.
Therefore $M(\ce{Br})=[79.901, 79.907]\times 10^{-3}~\text{kg/ mol} \approx 79.90~\text{g/ mol}~\text{(4 s.f.)}$ (based on the reference value).
When calculating with molar masses $M$ one always has to keep in mind, that the used standard values are based on a (global) statistic.
Related definitions:
amount of substance, $n$, Also contains definition of: number of moles
Base quantity in the system of quantities upon which SI is based. It
is the number of elementary entities divided by the Avogadro constant.
Since it is proportional to the number of entities, the
proportionality constant being the reciprocal Avogadro constant and
the same for all substances, it has to be treated almost identically
with the number of entities. Thus the counted elementary entities must
always be specified. The words 'of substance' may be replaced by the
specification of the entity, for example: amount of chlorine atoms,
$n_\ce{Cl}$, amount of chlorine molecules, $n_{\ce{Cl2}}$. No
specification of the entity might lead to ambiguities [amount of
sulfur could stand for $n_\ce{S}$, $n_{\ce{S8}}$, etc.], but in many
cases the implied entity is assumed to be known: for molecular
compounds it is usually the molecule [e.g. amount of benzene usually
means $n_{\ce{C6H6}}$], for ionic compounds the simplest formula unit
[e.g. amount of sodium chloride usually means $n_{\ce{NaCl}}$] and for
metals the atom [e.g. amount of silver usually stands for
$n_{\ce{Ag}}$]. In some derived quantities the words 'of substance'
are also omitted, e.g. amount concentration, amount fraction. Thus in
many cases the name of the base quantity is shortened to amount and to
avoid possible confusion with the general meaning of the word the
attribute chemical is added. The chemical amount is hence the
alternative name for amount of substance. In the field of clinical
chemistry the words 'of substance' should not be omitted and
abbreviations such as substance concentration (for amount of substance
concentration) and substance fraction are in use. The quantity had no
name prior to 1969 and was simply referred to as the number of moles.
relative molecular mass, $M_r$
Ratio of the mass of a molecule to the unified atomic mass unit.
Sometimes called the molecular weight or relative molar mass.
relative molar mass
Molar mass divided by $1~\text{g/ mol} (the latter is sometimes called the standard molar mass).