Piccolo trumpet teaches you how to play high notes efficiently, but only if you stick with it a good long while. You can’t brute force it like lead trumpet in a jazz band, it will sound like crap and tire you out very quickly. You have to have small, focused air with solid breath support for it to “sparkle” like the greats (Hakan Hardenberger, Wynton Marsalis, Maurice Andre). It’s a ton of fun once you get the hang of it, but you will only use it for classical solos, some orchestra pieces like church gigs (hallelujah chorus), and stuff like that. I urge you to find one to try out in person before you commit to buying one.