Sweet onions are simply my favorite preference when making vegan onion rings because I think the onion flavor is simply less intense.  But I’ve also not been able to find sweet onions at times.  Your best option is to simply choose another onion with a yellow skin.  Yellow onions are generally less intense in flavor than red onions or white onions, making them better suited for onion rings.