It generally means sitting in the first row at an event, like the opera, a play, a show or even the movies.

The expression does not have to be the literal meaning, however. You can have a "front-row seat" to something even if you are not physically present. It's more about how closely you experience the event.