The simplest way would probably be to add a projectile movement component to the object. That has a built in function for making the object rotate towards its movement direction.
Alternatively, you can do something like this:
Add on some rotation interp to smooth it out, but that itself will give you the rotation you want, assuming the actor’s “forward” is along positive X in local space.