Magnesium supplements have caught influencers’ attention and long been praised for promoting healthy sleep. Here’s what the science shows.