The only potential long-term risk I wonder about is antibody dependent enhancement [1] for future variants of the virus. But, that has nothing to do with whether the vaccine uses mRNA or an attenuated virus. Those involved in making a vaccine are very much aware of this issue and design vaccines to avoid it.

[1] https://en.m.wikipedia.org/wiki/Antibody-dependent_enhanceme...