Do you believe that even a bad singer can one day become a good singer with vocal training ?

Or is it the case that some people just do not have a note in their head lol.?

Depends how you define bad.

Imo, you can’t teach someone to sing in tune if they can’t already do it naturally.

Vocal training works well to bring out the best of a good voice, rather than turn a bad one good.