I use KRename for renaming multiple files.

krenamer can do this. It just is a regex front end. You could do it with a shell script too.

how can you identify season from the file name?

Please don't use spaces in your *nix filenames, that is just bad. To answer your question, use a bash script. Chatgpt can probably even make it for you if you don't know how to write it.

There must be a million utilities to do this (try searching "linux mass rename"), including ones that allow you to rename media files based on their metadata... each works in different ways, so you'll have to look yourself for one that fits you (personally, I like the ones who open a text editor with the file names and you just edit them).

If you use KDE (DK about other environments) and only need a progressive counter, the simplest way is just select the files in dolphin, hit F2 and enter a pattern like "Tv Show Episode S01E##.mp4".

(of course you can also write a script to rename the files, but I guess you wouldn't have asked if you were prepared to do so)

you can try rename: https://www.man7.org/linux/man-pages/man1/rename.1.html

or
rename 's/expression/replacement/' filename

select range of episodes per season then add season number (eg S01) in replacement string.

then restart numbering for next set of episodes (eg 01 to 12) and add S02. and so on. more tedious than the gui Rename method but doable.

Why not just do this with a for loop in the terminal? I don’t think you need to over complicate it by downloading another program.