Sigma lists the maximum reproduction ratio of that lens as 1:2.9, or 0.34X maximum magnification (MM). That's about one third of the 1:1 reproduction ratio that most photographers consider to be a true macro lens.
If you have the Canon EF-S 55-250mm f/4-5.6 IS STM or EF-S 55-250mm f/4-5.6 IS II, they both have a maximum magnification of 0.31X, which is nearly identical to the Sigma lens. The older Canon EF-S 55-250mm f/4-5.6 IS has a slightly smaller MM of 0.29X.
Your current Canon 55-250mm lens (any of the the versions) is also a better overall lens optically in the focal lengths they share in common with the Sigma 18-250mm f/3.5-6.3 DC Macro OS HSM. You would really be gaining nothing with regard to macro photography by swapping from your EF-S 55-250mm to the Sigma 18-250mm.
If you really want to do macro photography, you need to consider a true macro lens with a 1:1 reproduction ratio/1.0X MM. Such lenses are almost always prime lenses. That is, they are lenses with a single focal length that does not "zoom". This allows them to be optimized for that single focal length. Additionally, true macro lenses tend to be optimized to perform best at the closest focus distance or minimum focus distance (MFD).
In the Canon system, you could consider anything from the new EF-S 35mm f/2.8 Macro IS STM that has an innovative light built in to the front of the lens, a used (discontinued) EF 50mm f/2.5 Compact Macro, an EF-S 60mm f/2.8 Macro, two different 100mm f/2.8 macros lenses (one is in the "luxury grade" "L" series), or even an EF 180mm f/3.5 L Macro.
Then there's the unique Canon MP-E 65mm 1-5X Macro. It has a variable MM of 1.0X to 5.0X. It also only has a single focus distance for each reproduction ratio and can not focus further than 100mm in front of the lens at 1.0X. At 5.0X it can only focus 41mm in front of the lens and no further!
Note that your Canon EOS Rebel T7i/800D can use either EF-S or EF lenses. If you ever move to a full frame Canon camera, you will only be able to use EF lenses. Also note that the EF 50mm f/2.5 Compact Macro has an MM of 0.5X (1:2), rather than an MM of 1.0X (1:1).
There are also some great third party macro lenses made for the Canon EF mount. Tamron has released a series of 90mm macros that are very well regarded by many. The current lens in that series is the Tamron SP 90mm f/2.8 Di Macro 1:1 VC USD (Model F017). The name is very similar to previous Tamron 90mm f/2.8 Macro lenses, so be sure you are getting the one you think you are!
For some related questions here at Photography.SE, please see:
Variable focal length for macro lenses?
How do focal length, minimum focus distance, and magnification interact on a lens?
What does "magnification" mean?
What kind of lens to photograph a 1 mm object?
Variable focal length for macro lenses?
Why is the Tamron 90mm 2.8 marketed as Macro and not as a "portrait" lens?
How to choose lens for macro photography?
How can I take a macro shot without a macro lens?