I haven’t seen any aligned double or long tearing for over 20 years on workstation or server CPUs.
AIUi
Memory model strength has nothing to do with tearing. Total store order and total load order does not matter in any possible way.
There's no tearing, because all memory operations are wider than 64-bits. Unless someone purposefully performs two 32-bit operations on a single 64-bit value.