I agree that the intro is kind of nutty in how long it is, I also think it’s a great part of the show. It really got me “ready to watch” and brought me out of whatever else was going on and into... Twin Peaks.
That being said, I only first watched the show in the last few years, early 30s. Would almost certainly driven me crazy earlier in life.
https://youtu.be/i7d0Lm_31BE