Is it normal, when working for many years on a big software project, to feel both "this is going great!" and "this is so far from how it should be ugh!" at the same time?

Recordings:

Decanted Youth - 1 - Frozen Again -- [9:30]
Decanted Youth - 2 - Twenty Six Thing Mini -- [0:43]
Decanted Youth - 3 - Sandman -- [7:00]
Decanted Youth - 4 - Light Creeps -- [12:32]
Decanted Youth - 5 - (Not) Major Major Major -- [5:07]
Decanted Youth - 6 - The Squeeze -- [6:17]
Decanted Youth - 7 -- [2:18]
Decanted Youth - 8 -- [7:53]
Decanted Youth - 9 - Insecurity Six -- [2:50]
Decanted Youth - 10 - Insecurity -- [5:39]
Decanted Youth - 11 - Hard Reflections -- [10:16]
Decanted Youth - 12 - A Taste of Juice Carrots -- [0:51]
Decanted Youth - 13 - Another Taste of Juice Carrots -- [3:14]
Decanted Youth - 14 - (Taste) Bad at Math -- [1:37]
Decanted Youth - 15 - Virgins Again (slow) -- [3:55]
Decanted Youth - 16 - Virgins Again (normal) -- [1:46]
Decanted Youth - 17 - Virgins Again (fast) -- [2:30]
Decanted Youth - 18 - Virgins Again (bridge dev) -- [2:35]
Decanted Youth - 19 - Virgins Again (not sure why I left this in) -- [0:39]
Decanted Youth - 20 - Virgins Again (ok really enough) -- [1:51]
Decanted Youth - 21 - Quicksand -- [3:31]
Decanted Youth - 22 -- [8:00]
Decanted Youth - 23 -- [3:58]
Decanted Youth - 24 -- [15:02]
Decanted Youth - 25 -- [6:24]