What’s the story with Lowell?

I came to the Boston area from FL 10 years ago, 8 of those were without a car. I’ve been exploring historic places and have been to Lowell twice now. There are tons of parking garages which tells me there must be some big events in the summer. There are tons of beautiful buildings in a big, walkable downtown yet barely any stores or restaurants remain open. Mill number 5 is such a cool location and I had one of the best lattes of my life at Coffee and Cotton. Tons of affordable houses on Zillow. Yet I never hear about young families moving up there. All I’ve been able to find out from friends is “the schools aren’t good”. Can anyone else add context to this? Is Lowell worth moving to and investing in?