Caution, this cannot really be generalised, but depends above all on the genre. Soft jazz pieces or ballads are not comparable with metal songs.
Often the cymbals or the snare are perceived as particularly loud directly on the drums. However, what the neighbours hear most are the low frequencies of the kick drum. This is due to the nature of low frequencies; their wavelength is longer and requires much thicker materials to shield them. Everyone knows the phenomenon of hearing only the boom of the kick outside the nightclub, while you only notice the details of the song when you enter the club.
Nevertheless: even in general, drums are already a very loud instrument. It's not for nothing that drummers should wear ear protection. A drum kit can get quite loud at 110 decibels, which is about the same as the volume of a chainsaw.
If you don't have a suitable basement or practice room, you should look for electronic drums. If you are willing to spend a little money, you can count on very good alternatives to acoustic drums.