Musk’s intervention helped derail a crucial government funding bill, but some political observers question how long the alliance can last