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:
$303 per person with Volaris
$351 per person with Aeromexico
$435 per person with Swoop