The former ‘Saturday Night Live’ star speaks to Louis Chilton about bygone life in a touring band, the surprise success of Netflix’s ‘Wednesday’, and his ‘utilitarian’ new album, comprised of 101 sound effects