A Scottish Labour MP has urged voters no to use Holyrood 2026 as a referendum on Sir Keir Starmer amid bleak polling.