Fix spawn_tps_frontend

For some reason, on Debian Bookworm the transient scope units started by systemd-run --scope are terminated when the parent process terminates.

Using a transient service instead fixes that.

Closes #20141 (closed)

Based on !1367 (merged) so we get more relevant test results.