So even if we don't take into account the extra time it's still about twice as expensive as by car (about 12€ one-way on diesel) and then the train does not depart from my home, and I still have a metro to take in Lille to get to the office.
If the various transport networks were better integrated though, it could be at least as fast and as convenient as by car. A first step would be not needing between six and four different tickets for a round-trip: De Lijn for the tram in Antwerp (and/or Velo passes for the shared bikes) SNCB for the train departing from Antwerp, Transpole for the metro in Lille (and/or V'Lille for the shared bikes) and SNCF for the train departing from France.
I've tried very hard to look for something that would make taking the train even remotely competitive with using my car, but unfortunately there is absolutely no convenient option in my particular case (and even in the more common cases, train is just as cheap or as fast as car in the best case, rarely better).
And It's not all about cost. Just to add two factors that you might want to consider as relevant::
How can you use the time. Eg in a train you can read a book, do an online course, ... even work if you feel the need. I'd choose a 2h train ride any time over a 90 minute drive. Twice a week 60 minutes spent on a good course book or online course will in the long term give you much more value than the price of the train ticket compared to the price of gas.
And of course environment-wise the choice is obvious.
https://www.adac.de/infotestrat/autodatenbank/autokosten/aut...