I think it's important to realize that you're not alone here. You'll be among many people that moved from LI to NC. Charlotte ia a big hodgepodge of many different people from all over. I moved here from LI 20 years ago and it was much different back then. Charlotte is ever growing and just an out and out joy to be in. When I travel to LI I shake my head at most things like the traffic, expense, crowds and the only thing I miss is the food
, but you adjust you know.
My kids are about to start school in a year, but I think from what I gather the schools may not be as "good" as LI schools, but we do OK. I would guess you'd research a good area to make sure you're in the right district for the better schools.
Other than that, there's plenty to do here and I think you'll love it.