This is a decent idea. You can configure the VPS to be an exit node on the Tailnet, and configure the clients to use it as their exit node. Then you'd just need to configure some nftables rules to masquerade (source NAT) to the VPN network interface.
Having said that... At that point, why do you need the other VPN? You can just use the VPS as your exit node.