I highly recommend it. Sweet onions are milder than other varieties like white or yellow onions and they caramelize beautifully in the hot butter with the sliced mushrooms. Here's a great article in Bon Appetite about the differences between onion varieties.