For independence to happen, Yes needs to win over 5-10% of the electorate—people who are currently unconvinced by the economic case, worried about division, or simply want to focus on other issues. That is possible, but it requires a better campaign, better answers, and probably a significant external shock.
In the meantime, Scotland remains divided, the debate remains unresolved, and the polling remains stuck. The 2014 referendum was supposed to settle the question for a generation. It settled nothing. And until one side can build a sustained majority, that is unlikely to change.