A secondary effect, however, could be that it temporarily wrecks the fracking industry in the US, eventually leading to much less natural gas production, raising the price of natural gas (and thus being good for wind/solar, which will probably have gradually declining costs for the foreseeable future).
Not really. Hybrid vehicles for example tanked the last time oil prices plummeted.
https://www.handelsblatt.com/unternehmen/industrie/autozulie...
https://www.handelsblatt.com/unternehmen/industrie/zuliefere...
At the end of the day renewable energy is just producing a commodity product - electricity. As fossil fuels decline in price the wholesale price of electricity declines making it less attractive to build wind/solar etc. Existing plants will obviously stay online but people who invested in that sector will be hit.
High enough oil prices and people invest in alternatives But oil and its products are used in the production of many renewable infrastructure too ... so there's a point of diminishing returns.
And at this point the issues of long distance transportation and large scale production are hurting both ends.