I think it's really cute, but I don't foresee it making a comeback, either. It doesn't seem to fit the trend as well as a lot of other names.
I like the spelling
Louisa more than
Luisa, and both better than
Louise and
Luise.
Lou would be a nice nn, but I had a dog named
Lulu, so I personally would never use that one.
:]