The closest airport to Rosarito Beach is Tijuana Airport, which is located in Rosarito. If you plan on visiting or staying in this area, landing at Tijuana Airport will be your best bet.
The best prices found on momondo for flights to Mexico are:
$84 per person with Volaris
$182 per person with Interjet
$190 per person with American Airlines