Looks curdled, but it wasn't - my bad alfredo
Emulsions aren't necessarily all about oil vs. water. Alfredo sauce is actually an emulsion of cream and butter, both of which contain varying amounts of both water and fat, and in many cases, if you bought them from a supermarket rather than a farm, also a fair amount of emulsifiers.

Any emulsion is going to be temperamental and not respond well to sudden changes in dispersion. The most important thing to do with one is incorporate new ingredients slowly! If you just dump in a bunch of watery tomatoes, or anything else with enough liquid (water or fat), it's almost certainly going to separate.

Even if you incorporate very slowly and thoroughly, if you upset the balance too much, it might still break. There's no way to know the exact amount you can add without experimenting, unless somebody else has already documented it (not likely).

Sometimes, if your emulsion just creams (see my related answer about mayonnaise), you can restore it to its former glory with sufficient agitation. If it's actually broken then you're in trouble.

Anyway, my advice to you would be - if you want a rosé sauce, then make a rosé sauce, don't waste a lot of time and perfectly good Reggiano cheese trying to start from an Alfredo recipe. I've made a great many tomato and/or pesto cream sauces and the general rule with these (including Alfredo) is that you always start with any oil and vegetables (garlic, tomatoes/paste, etc.), then add your seasonings, then add the cream and slowly reduce it. You don't need or want butter at this point, its flavour will be completely overwhelmed by the other ingredients and it therefore just adds instability.

You might also want to consider using sun-dried tomatoes for a stabler and probably tastier result; they essentially classify as a solid as far as emulsions are concerned, so it's not much different from incorporating pepper or dried herbs. You could just make a regular pesto cream sauce and whisk in some sun-dried tomatoes near the end.