Preheat the oven to 325°F (163°C).
In a small bowl, combine salt, black pepper, garlic powder, onion powder, smoked paprika, dried thyme, and dried rosemary to create a spice rub.
Pat the brisket dry with paper towels and rub the spice mixture evenly over all sides of the meat.
Heat olive oil in a large oven-safe pot or Dutch oven over medium-high heat. Brown the brisket on all sides until a golden crust forms, about 4-5 minutes per side.
Remove the brisket from the pot and set it aside. In the same pot, add onions, carrots, and garlic. Sauté for 3-4 minutes until the vegetables are slightly softened.
Deglaze the pot with red wine (if using), scraping up any browned bits from the bottom.
Stir in beef broth, Worcestershire sauce, and tomato paste. Bring the mixture to a simmer.
Place the brisket back into the pot, ensuring it's nestled among the vegetables. Cover the pot with a lid or foil.
Transfer the pot to the preheated oven and roast for about 2.5 to 3 hours, or until the brisket is fork-tender.
Remove the pot from the oven and let the brisket rest for 10-15 minutes before slicing it against the grain.
Serve the Young Sheldon Brisket with the flavorful vegetables and a ladle of the cooking liquid.