How to bring an application made in Automator to the foreground upon launch?
Have a look at the activate command in the AppleScript Language Guide Commands Reference.


  activate  Brings an application to the front, and opens it if it is on the local computer and not already running.


I'd add activate me after the start of the on run handler.