while it would make a lot of pain to Russia, it wouldn't change the strategic situation. Russia is ok with taking the pain (more precisely Putin and his ilk are ok with subjecting Russia to the pain)
You need strategic hits, a knock-out, making it physically impossible for them to continue as it is the only language they currently understand. So, for example, Russia has like 10K of S-300/400 missiles. That is key part of the strategic defense of Russia (notice how Russia recently had a hysteric meltdown when just one drone hit their strategic defense radar thus slightly impacting their defense against ICBMs/etc. and also notice that just a drone was able to hit such a valuable target) Ukraine can build several thousands of large drones (cheap, simple, like say German V-1, can be built for less than $5000 each including modern navigation, Germans built 20K of V-1 in year in just one factory inside the mountain) and fire them to the targets in Russia choosing routes, altitudes and targets such that Russia would have to use S-300/400 instead of say shorter range BUK/Tor/Pantsir (Russia is big and most of the coverage is naturally by the S-300/400). After several thousands of such drones Russia would be put into impossible situation - either to let those large drones (original V-1 had 850kg warhead, ie. double that of Tomahawk/Storm Shadow/SCALP) fly and hit the targets or to run out of strategic air defense.