If a second referendum was held and voted to remain in the Union, she would still want a third.
Of course you can keep holding referendums until they get the vote they want, but would they hold another one to rejoin after that? I very much doubt it.
Mind you, if the English were offered a vote to see if Scotland should remain and they voted them out, the SNP would probably reject it as it wouldn't have been voted by them...